Re: [SQL] stored procs in postgresql

am 24.09.2005, um 21:10:48 -0700 mailte Cere Davis folgendes: > thanks, > > I didn't even know about the string concatination function for this. > Unfortunately, it was of no help. Specificly I am trying this, with > the following error: > > SQL error: > > > ERROR: syntax error at or near "

Re: [SQL] stored procs in postgresql

thanks, I didn't even know about the string concatination function for this. Unfortunately, it was of no help. Specificly I am trying this, with the following error: SQL error: ERROR: syntax error at or near "' || $2 || '" at character 110 In statement: CREATE FUNCTION "getcensusbound" (g

Re: [SQL] stored procs in postgresql

[EMAIL PROTECTED] writes: > I have been having some trouble with plsql stored procs in postgres in > that I can > make a table name a variable in the stored proc. Is there some > special way to make this happen that I am unaware of? > > For example, I want to do something like: > > stored_proc(in

[SQL] stored procs in postgresql

Hi, I have been having some trouble with plsql stored procs in postgres in that I can make a table name a variable in the stored proc. Is there some special way to make this happen that I am unaware of? For example, I want to do something like: stored_proc(integer,varchar) SELECT table_