All pastes #90385 Raw Edit

Someone

public text v1 · immutable
#90385 ·published 2006-07-17 17:04 UTC
rendered paste body
CREATE TABLE artist_strings (
    artiststrid SERIAL,
    artist character varying(60) NOT NULL
);
ALTER TABLE ONLY artist_strings ADD CONSTRAINT artist_strings_artist_key UNIQUE (artist);
ALTER TABLE ONLY artist_strings ADD CONSTRAINT artist_strings_pkey PRIMARY KEY (artiststrid);


StartTransaction;
INSERT INTO artist_strings
( artist
 ) VALUES ( 
 :artist
)

SELECT artiststrid
FROM artist_strings
WHERE artist= :artist

Commit;