[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D

[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D

[GENERAL] cidr and inet

1999-10-21 Thread soundar rajan
Hi all, I created two tables with CIDR and inet data values separately. I was not able to insert values into it. When I tries to do insert into ip values (10.20.30.40); the error I get time and again is 'parser error at or near .30' It always points to the third part of the IP (ie, 100 in c

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc problem

1999-10-15 Thread soundar rajan
Hi, I am using postgresql under linux. Now that I need to build up the jdbc driver for postgresql, when I make under the directory /src/interfaces/jdbc.. I get an error stating '(u' unexpected syntax... The version returned by the make is 1.0b4. The makeVersion.java file returns jdbc0 as the

Re: [GENERAL] how to insert a date

1999-10-15 Thread soundar rajan
n the last qn. so as to be interpreted the way you meant it. Thanks. Soundar. --- Kevin Heflin <[EMAIL PROTECTED]> wrote: > On Fri, 15 Oct 1999, soundar rajan wrote: > > > hi, > > Can anyone help me -- how to insert a date value > into > > a postgresql db >

[GENERAL] how to insert a date

1999-10-15 Thread soundar rajan
hi, Can anyone help me -- how to insert a date value into a postgresql db Thanks in advance. __ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com