Thanks for your help. I'm going to use this bit of functionality once
or twice, so I went ahead and worked around it in an inelegant, but
effective manner.
Oh well.
Walter
On Tuesday, April 1, 2003, at 10:03 PM, Tom Lane wrote:
Walter McGinnis <[EMAIL PROTECTED]> writes:
When I call the fun
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> Er ... you just want to bump the sequence and throw away the actual
>> value? You don't want to store the value somewhere?
> Correct
Then you need something like (untested)
CREATE FUNCTION mytrig() RETURNS TRIGGER AS '
begin
perform nextval(''
Hi all,
I am moving the database from sybase to postgresql.Iam having problem
replacing the following similar syntax from sybase to postgres sql could
anybody help me out? It doesnt seem to recognize the '?' operator though it
works fine in Sybase.
select * from version where version_nr =?;
ER