Re: [GENERAL] postgresql query

2013-06-24 Thread Jashaswee
i have tried in that way but its showing that the debit column doesn't exist -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-query-tp5759846p5760593.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general maili

Re: [GENERAL] postgresql query

2013-06-24 Thread Jashaswee
i am using postgresql 8.4 version..but this doesn't support the function -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-query-tp5759846p5760589.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing l

[GENERAL] postgresql query

2013-06-19 Thread Jashaswee
I have numeric values in a numeric column.the column has two parts.i want to split in 2 differnet column . The column value looks like this: Quantity 2000 -1000 both the quantity values are of a same product.but i want these in a single line. so what i want is a result set that looks like: In

Re: [GENERAL] How to convert numbers into words in postgresql

2013-05-15 Thread Jashaswee
thnx for your help albe. i went through this code its working fine . -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-convert-numbers-into-words-in-postgresql-tp5755370p578.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

[GENERAL] How to convert numbers into words in postgresql

2013-05-14 Thread Jashaswee
i want to convert numbers into words in postgresql.is there any query for it? if yes please reply soon -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-convert-numbers-into-words-in-postgresql-tp5755370.html Sent from the PostgreSQL - general mailing list archive