On Thu, May 19, 2005 at 03:17:07PM -0400, Mark Fenbers wrote:
>
> I need to create an aggregate function to do some math not currently
> provided by the available tools. Can someone point to an example
> aggregate function syntax that I can use as a template for my own
> function. I'm still a
I need to create an aggregate function to do some math not currently
provided by the available tools. Can someone point to an example
aggregate function syntax that I can use as a template for my own
function. I'm still a little green on some aspects of PostgreSQL and am
drawing a blank on ho
You should considder a variation as Volkan suggested.
Otherwise the EXECUTE command might be what you are looking for.
Execute a sql made up in a string
|-Original Message-
|From: bandeng [mailto:[EMAIL PROTECTED]
|Sent: Donnerstag, 19. Mai 2005 04:11
|To: pgsql-sql@postgresql.org
|Subjec
|PFERL_Robert?= <[EMAIL PROTECTED]> writes:
|> Thus I run VACUUM ANALYZE; every night by cron. However I
|keep getting
|> ERROR: tuple concurrently updated
|
|Have you got other processes also doing VACUUM ANALYZE? The only known
|reason for this to happen is that two processes concurrently
|A
Hi,
On 5/19/05, bandeng <[EMAIL PROTECTED]> wrote:
> i want to make dynamic sql query like this
>
> select * from tb_cust where name='erick' and age='20'
>
> to
>
> select * from tb_cust $1
>
> i have tried but error comeup
I think there's a confusion about the usage of parameters like $1, $2
bandeng wrote:
hello all,
i want to make dynamic sql query like this
select * from tb_cust where name='erick' and age='20'
to
select * from tb_cust $1
i have tried but error comeup
You have tried what? How? What error did you get?
--
Richard Huxton
Archonet Ltd
---(end o
