Re: INSERT with RETURNING clause inside SQL function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Diego Schulz" <dschulz(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT with RETURNING clause inside SQL function
Date: 2008-11-04 05:38:23
Message-ID: 12147.1225777103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Diego Schulz" <dschulz(at)gmail(dot)com> writes:
> On Mon, Nov 3, 2008 at 10:24 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>> Just curious - what have you got against currval()? It seems to me that
>> it would make your life easier....

> I simply don't like having to cast from BIGINT to INTEGER,

Under what circumstances do you need an explicit cast?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-11-04 07:49:33 Re: I'm puzzled by a foreign key constraint problem
Previous Message Jonathan Guthrie 2008-11-04 03:45:37 I'm puzzled by a foreign key constraint problem