Re: [SQL] Obtaining the primary key of the record just inserted

On Nov 8, 2007 11:56 AM, Oliveiros Cristina <[EMAIL PROTECTED]> wrote: > > Hello, All, > > I have the need to know the primary key assigned to a record I've just > INSERTed . > > Is there an easy way to solve this ? > > Similar to SQLServer's SELECT scope_identity() ; ? In 8.2 and up: insert int

Re: [SQL] Partitioning and Foreign Keys

On Nov 4, 2007, at 12:57 PM, Volkan YAZICI wrote: major bottleneck. I planned to partition this table, but I learnt that PostgreSQL doesn't allow referencing views. Does anybody have any suggestions? I can envision writing your own custom trigger instead of using the stock FK trigger that

[SQL] Obtaining the primary key of the record just inserted

Hello, All, I have the need to know the primary key assigned to a record I've just INSERTed . Is there an easy way to solve this ? Similar to SQLServer's SELECT scope_identity() ; ? Any help deeply appreciated Best, Oliveiros

[SQL] quote_nullable alternative?

Hi, There has been a recent discussion on the hacker mailing-list recently, regarding a new patch for postgresql, that returns 'NULL' instead of NULL when a NULL value is passed as a parameter. It's exactly what I need on my 8.2.5 server. Is there an alternative to patching the server in order t

Re: [SQL] Obtaining the primary key of the record just inserted

It worked perfectly. Thanks a million, Scott. Best, Oliveiros - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "Oliveiros Cristina" <[EMAIL PROTECTED]> Cc: Sent: Thursday, November 08, 2007 6:03 PM Subject: Re: [SQL] Obtaining the primary key of the record just insert

Re: [SQL] quote_nullable alternative?

[EMAIL PROTECTED] wrote: > Hi, > > There has been a recent discussion on the hacker mailing-list > recently, regarding a new patch for postgresql, that returns 'NULL' > instead of NULL when a NULL value is passed as a parameter. > > It's exactly what I need on my 8.2.5 server. > > Is there an