Re: [SQL] plpgsql exception handling

On Wed, Mar 9, 2011 at 2:08 PM, Samuel Gendler wrote: > when I run 'select 1count(*) from table' in my postgres 8.4 installation, I > get the exact same error message.  Assuming the '1count()' function does > exist, perhaps you need to full qualify it with a schema name? > It looks to me like the

Re: [SQL] plpgsql exception handling

when I run 'select 1count(*) from table' in my postgres 8.4 installation, I get the exact same error message. Assuming the '1count()' function does exist, perhaps you need to full qualify it with a schema name? It looks to me like the query you are passing to the procedure is invalid and is gener

[SQL] plpgsql exception handling

Hi, I'm trying to run an execute with a dynamic sql command within a function. I need a clean exception handling here, but my version does not work somehow. I want to trap a possible syntax error and write the error code, error message and the sql into a table. the function looks similar to this

Re: [SQL]How to transform table rows into Colum?

Hey Eric, 2011/3/9 Eric Ndengang > Hi Guys, > I have the following table: > > Name Value rang salary > > name1 value1 12500 > name2 value2 22600 > name3 value 3 3300 > > and want to obtain the following result: > > name1 name2 name3

[SQL]How to transform table rows into Colum?

Hi Guys, I have the following table: Name Value rang salary name1 value1 12500 name2 value2 22600 name3 value 3 3300 and want to obtain the following result: name1 name2 name3 value1 value2 v