Re: [SQL] pesky plpgsql

2003-04-02 Thread Walter McGinnis
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

Re: [SQL] simple trigger question ...

2003-04-02 Thread Tom Lane
"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(''

[SQL] Syntax problem!

2003-04-02 Thread mohamed imdadullah
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