Re: [GENERAL] issues with java driver setDate() on function call

2008-08-02 Thread Ismael ....
sorry, just discovered the answer, only need to cast the value like this String sql = "SELECT * FROM insertaEgreso(?, ?, ?::DATE, ?, ?, ?)"; pst.setDate(3, date); :) > > > I have a function declared as follows > CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importe

[GENERAL] issues with java driver setDate() on function call

2008-08-02 Thread Ismael ....
I have a function declared as follows CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1 numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1 character varying, comentarios1 character varying) RETURNS integer ASimplementation notice the field "fech

[GENERAL] Alternative way to access a field in a %ROWTYPE variable

2008-07-30 Thread Ismael ....
Hi, Is there another way to access to the field in a variable of type record? I need to store the name of a field in a variable and access the field whose name matches the content of the variable. Just as an example of what I want to do, the table or view "pg_user " has at least the field usenam

Re: [GENERAL] in query variables....

2008-07-17 Thread Ismael ....
> > Hi all, > > this is from the is there a way file. > Is there a way to get the name of the relation or relations in a query > from within the query? Like some kind of magic variable...? > for example : > "select *, from thistable" > where would be replaced by thistable. > >

Re: [GENERAL] deleting the master but not the detail

2008-07-17 Thread Ismael ....
> >> So is there no other way to do it but to verify the integrity using triggers >> and drop the referential constraints? > > Well, you could do something using a before delete trigger on the > referencing table that returns NULL to avoid the delete as well, but > making it only prevent the de

Re: [GENERAL] deleting the master but not the detail

2008-07-17 Thread Ismael ....
It seems like 3 vs 1 so you win :) I'll drop the constraint and verify the integrity of the new records manually tanks > > On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught wrote: >> On Thu, Jul 17, 2008 at 12:11 PM, Ismael wrote: >>> >>> hi &g

Re: [GENERAL] deleting the master but not the detail

2008-07-17 Thread Ismael ....
So is there no other way to do it but to verify the integrity using triggers and drop the referential constraints? Because I *still* need to verify that NEW records in the details table direct to something that exists > >> ON DELETE RESTRICT | NO ACTION won't let me delete the master >> CASCAD

[GENERAL] deleting the master but not the detail

2008-07-17 Thread Ismael ....
hi I have one of those master-detail relationships here and I need to be able to delete the master but leave the details untouched But the delete command doesn't let me delete the master as long as there are details referencing it. ON DELETE RESTRICT | NO ACTION won't let me delete the master CA

Re: [GENERAL] How to create my own result set?

2008-07-15 Thread Ismael ....
I'll try with what says in the FAQ, but should someone know of a way to declare a variable that allows appending please tell me http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions > > > Hi there, > I'm making a rea

[GENERAL] How to create my own result set?

2008-07-15 Thread Ismael ....
Hi there, I'm making a really weird stored procedure which makes use of about 5 tables... and I need to create my own result set based on the computed result of various FOR loops. Does anyone knows how can I do that using PL/pgSQL? I "think" I need to declare a couple of variables that accept AP

Re: [GENERAL] storing latitude and longitude

2008-07-10 Thread Ismael Almaraz Ezparza
Sorry I'm not of much help but... did you check the data types page? http://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-geometric.html http://postgresql.mirrors-r-us.net/docs/8.2/interactive/datatype-numeric.html That mainly depends on how many digits you need to store, if that's no

Re: [GENERAL] How to obtain info about the user?

2008-07-10 Thread Ismael Almaraz Ezparza
n Thu, 2008-07-10 at 11:08 -0500, Ismael Almaraz Ezparza wrote: >> Hi there, >> I'm connecting to postgres from java using the postgres driver... >> and I need to get the info about the user that is connected to the DB, lets >> say >> for example: name, groups, permis

[GENERAL] How to obtain info about the user?

2008-07-10 Thread Ismael Almaraz Ezparza
Hi there, I'm connecting to postgres from java using the postgres driver... and I need to get the info about the user that is connected to the DB, lets say for example: name, groups, permisions (select, update, execute)... Does anyone knows how can I get that info? Also, if the user is in the gr

Re: [GENERAL] JDBC error w/ WebObjects

2005-09-21 Thread Ismael Perdido
-- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database And I am able to both select and add rows without difficulty. Any direction here would be greatly appreciated. Thanks and regards, Ismael Jones [EMAIL PROTECTED