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
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
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
>
> 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.
>
>
>
>> 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
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
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
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
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
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
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
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
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
--
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
14 matches
Mail list logo