Re: very basic SQL question

From: Dan Kortschak <dan(dot)kortschak(at)adelaide(dot)edu(dot)au>
To: Matthieu Huin <matthieu(dot)huin(at)wallix(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: very basic SQL question
Date: 2010-11-23 20:40:37
Message-ID: 1290544837.3857.2.camel@sol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for that - yes very helpful. Good to know what is possible.

Dan

On Tue, 2010-11-23 at 10:27 +0100, Matthieu Huin wrote:
> A similar question was discussed here about 3 weeks ago :
> http://archives.postgresql.org/pgsql-general/2010-11/msg00110.php
>
> The "UPSERT" facility not being implemented yet, I don't think it is
> possible to do much better than what you came up with.
>
> Assuming the column(s) holding the distinctive sequence data are defined
> with the UNIQUE constraint, you could adapt the example function given
> in the link to the documentation in the previous thread to achieve what
> you want.
>
> Hope this helps,
>
> Matthieu

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brar Piening 2010-11-23 21:05:10 Re: "could not accept SSPI security context"
Previous Message akp geek 2010-11-23 20:34:39 Passing a String with special character as an input