Re: [SQL] pesky plpgsql

2003-04-03 Thread Roberto Mello
On Thu, Apr 03, 2003 at 10:01:36AM -0800, Josh Berkus wrote: > Walter, > > > CREATE FUNCTION update_cat_keys() RETURNS integer AS ' > > declare > >v_row RECORD; > > What's in-between v_row and RECORD? Maybe a non-standard tab character? "non-standard tab character"? Are you saying

[SQL] pesky plpgsql

2003-04-03 Thread Walter McGinnis
Guess I'm an April Fool. When I define the following psql returns "CREATE": -- update all galleries that are categories with their skey and rkey values CREATE FUNCTION update_cat_keys() RETURNS integer AS ' declare v_row RECORD; begin for v_row in select gallery_id, imagedb_gallery_

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