On Wednesday 05 July 2006 16:46, Bjørn T Johansen wrote:
> I need to make a funtion that take one parameter and then returns a
> "record" with x number of fields, collected from x no. of tables, i.e. I
> need to run several sql statemtents to collect all the needed values from x
> no. of fields and
On Thursday 01 June 2006 15:39, Sean Davis wrote:
> You might look into Eclipse (the java-based IDE). It has at least one ERD
> design plugin that allows graphical layout, editing of schema, and
> generation of DDL directly from the schema. It works with many DB
> platforms and is FREE!!!
Would y
Hi,
Recently, I've decided to simplify the code of an application, to do that, I
migrate complex part to plpgsql function. I'd like to tune those functions,
how can I do that ? How can I get the executed SQL inside a function ??
Thanks in advance,
D.
---(end of broadc
On Friday 05 May 2006 13:06, Douglas McNaught wrote:
> "Paul Mackay" <[EMAIL PROTECTED]> writes:
> > I understand that the query plan of a function is determined at
> > CREATION and remains the same whatever the parameter(s) value. I
> > suppose then that this plan is stored somewhere in a system t
Hello, I would like to dump all my functions and only the functions from a
database, how can I do that ??
So far, I can only get it with
pg_dump -s dossier1|awk '/CREATE FUNCTION/,/LANGUAGE/ { print $0;}'
Regards,
D.
---(end of broadcast)---
T
On Monday 24 April 2006 10:43, Richard Huxton wrote:
(...)
> Do these two not solve your problem?
I knew those solutions, I was looking for a new one ;-) Because the " open in
execute" forces you to scan the whole table, that's what I wish to avoid, and
the "select count(*)" will be able to use i
If you have a look to the following code, I'm trying to work around the limitation about execute, which doesn't accept "select into". So I call the function with a table name as parameter, the function insert a record in a temporary table, retrieve it and return it.
The strange thing, is that the
