Hi,
I am writing a function in postgresql which inserts a row into the database,
but it is not working, can anybody help me out with a simple example.
thanx a lot.
Kris.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
references at this point).
Which tables do i need reference, could anyone
provide an example query?
Kris
dont need to use just those i
guess.
Kris
- Original Message -
From:
Dmitri
Colebatch
To: Kris ; [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 11:44
AM
Subject: Re: [SQL] Obtaining primary key
information from pg system tables
Kris,
I'm assumin
been suggested that ROWNUM could be replaced
by the nextval of a temporary sequence.
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ch09s05.html
Soon to be committed cvs version: can directly use server prepared
statements without using the SQL level PREPARE/EXECUTE.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
On Wed, 16 Jun 2004, Jie Liang wrote:
> Kris,
> Thank you for your valuable response, I used the code you list
> following:
>
> [7.5 code example]
>
> Then, the compiler complaint:
> ServerSidePreparedStatement.java:20: cannot resolve symbol symbol :
> metho
7;t know why this would be different for you. What exact version of
the server and driver are you using?
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Thu, 17 Jun 2004, Jie Liang wrote:
> Kris,
> I have another question, I saw some discussion regarding
> PreparedStatement work with array argument, I get a error when I try to
> play with it.
> E.g.
> I have myfunction(int[]),
> So,
> PrepareStatement st = conn
On Thu, 17 Jun 2004, Jie Liang wrote:
> Kris,
> You are right, I modified that piece of code a little bit,
> CallableStatement stmt = conn.prepareCall("{?=call chr(?)}");
> Then my log file were:
> Select * from chr(65) as result;
> Select * from chr(66) as result;
gh it doesn't use a server prepared
statement, and as I mentioned earlier the performance improvement if any
will be minimal. Have you done any testing to show that you are even
getting a performance gain?
Kris Jurka
---(end of broadcast)--
be found, but remember the
premature optimization adage.
>
> Secondly, I assume the function should be a pre-compiled object stored
> on server side, doesn't it.
>
I depends on the language the function is written. plpgsql caches plans,
but not all procedural
a known issue. It's on the list.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ATER VIEW v AS SELECT (a+b)::numeric(6,2) FROM tab;
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
eveal anything you
might try upgrading the JDBC driver to a later version.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Wed, 5 Jan 2005, Dave Cramer wrote:
> Kris is correct, this is a jdbc list, however to satisfy your curiosity,
> you can't access data from another database.
>
You certainly can with dblink which is what his question was about. I
didn't answer him because I remembered
Could you not create a function to do this instead?
Set var_limit = 20% of row count
Replace subquery with var_limit
Kris
On 18-Nov-09, at 14:27, Guillaume Lelarge
wrote:
Le mercredi 18 novembre 2009 à 20:24:09, Another Trad a écrit :
No, It doesn't.
In my machine:
First select
16 matches
Mail list logo
