Re: [SQL] SQL syntax rowcount value as an extra column in the result set
Thanks for all the dialog on this subject. My "version" was derived from the postgreSQL's .jar file (specifically named "postgresql-8.4-701.jdbc4.jar") that I'm using. When I do the following: select version() I get the following: PostgreSQL 8.3.6 I'm going to check this out. Thanks...Jim -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Thomas Kellerer Sent: Friday, March 26, 2010 3:15 AM To: pgsql-sql@postgresql.org Subject: Re: [SQL] SQL syntax rowcount value as an extra column in the result set Jayadevan M, 26.03.2010 07:56: > Thank you for setting that right. Apologies for not checking version. The orginal poster stated that he is using 8.4, so that solution will work for him. Thomas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] SQL Developer accessing PostgreSQL
Hello, Is there a way to configure Oracle's SQL Developer to access a PostgreSQL database? Thanks,Jim
[SQL] How do I search a two dimensional array?
I can search a one dimensional array with SELECT value = ANY(array), but how do I search two dimensional array for a particular row? ANY seems to flatten out a two dimensional array. [local]:playpen=> select 2 = any (ARRAY[[1,7],[4,2]]); ?column? -- t (1 row) Time: 52.451 ms [local]:playpen=> select ROW(2,7) = any (ARRAY[[1,7],[4,2]]); ERROR: operator does not exist: record = integer LINE 1: select ROW(2,7) = any (ARRAY[[1,7],[4,2]]); ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [local]:playpen=> select ROW(4,2) = any (ARRAY[[1,7],[4,2]]); ERROR: operator does not exist: record = integer LINE 1: select ROW(4,2) = any (ARRAY[[1,7],[4,2]]); ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [local]:playpen=> [local]:playpen=> [local]:playpen=> select ARRAY[2,7] = ANY( ARRAY[[1,7],[4,2],[6,8]]); ERROR: operator does not exist: integer[] = integer LINE 1: select ARRAY[2,7] = ANY( ARRAY[[1,7],[4,2],[6,8]]); ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [local]:playpen=> select ARRAY[1,7] = any ( ARRAY[[1,7],[4,2],[6,8]]); ERROR: operator does not exist: integer[] = integer LINE 1: select ARRAY[1,7] = any ( ARRAY[[1,7],[4,2],[6,8]]); ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [local]:playpen=> -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] SQL Developer accessing PostgreSQL
On 03/29/10 20:33, Snyder, James wrote: Hello, Is there a way to configure Oracle’s SQL Developer to access a PostgreSQL database? IMHO, no. And (even if it possible) it is completely useless, since the Postgresql has the "psql" program far better than any oracle tool and than all oracle tools together. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
