Thread: FW: simple? query

FW: simple? query

From
Jan Verheyden
Date:
Hi,

Thanks for the suggestion, the only problem is, if primary key is used then each row should be unique what is not true;
sinceI have a column 'registered' what only can be 1 or 0... 

Regards,

Jan

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Tim Landscheidt
Sent: Friday, August 14, 2009 4:53 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] simple? query

"Relyea, Mike" <Mike.Relyea@xerox.com> wrote:

>> The goal is, where uid not equals to 'janvleuven10' a new
>> record should be inserted with the uid, and registered=0

> So if a record is found you want to update it and if a record isn't
> found you want to insert it.  I think you'll probably want to use
> plpgsql http://www.postgresql.org/docs/8.4/static/plpgsql.html or some
> other language like Jasen suggested.  I don't know of a way to do this
> with straight sql.

Something along the lines of:

| UPDATE table SET attribute = 'something' WHERE primary_key = 'id';
| INSERT INTO table (primary_key, attribute) SELECT 'id', 'something' WHERE 'id' NOT IN (SELECT primary_key FROM
table);

should achieve that.

Tim


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: FW: simple? query

From
Tim Landscheidt
Date:
Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be> wrote:

> Thanks for the suggestion, the only problem is, if primary key is used then each row should be unique what is not
true;since I have a column 'registered' what only can be 1 or 0...
 
> [...]

I have no idea what you are trying to say.

Tim