[SQL] SQL Developer accessing PostgreSQL

2010-03-29 Thread Snyder, James
Hello, Is there a way to configure Oracle's SQL Developer to access a PostgreSQL database? Thanks,Jim

Re: [SQL] SQL syntax rowcount value as an extra column in the result set

2010-03-29 Thread Snyder, James
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

[SQL] SQL syntax rowcount value as an extra column in the result set

2010-03-25 Thread Snyder, James
Hello I'm using PostgreSQL (8.4.701) and Java (jdbc, postgresql-8.4-701.jdbc4.jar) to connect to the database. My question is: what is the SQL syntax for PostgreSQL to achieve the following: I want to receive the rowcount along with the rest of a result set. For example, let's say the following