[GENERAL] creating trigger

Hi all, I'm trying to create a trigger. I created a function which returns a count of the rows. I used this procedure while creating the trigger. But, I get an error stating SQL must return opaque. I tried the same with returning a varchar. I get the same error again. In simple words, I ne

[GENERAL] how to insert from sequence

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

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

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

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

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

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

bc0 as the output and so, the postgresql.jar file is not been created. How do I go about this? Any help would be appreciated. Thanks. Soundar. __ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com

Re: [GENERAL] how to insert a date

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

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