I just wanted to get a sanity check on using overloading in
PL/pgSQL.
MY application sends XML requests to a perl script, which has to
parse them and turn them into queries which get sent off, then the
results are put back into XML, and sent back to the client.
The XML language is pretty
On Wed, Mar 29, 2006 at 12:19:03PM -0800, Joshua D. Drake wrote:
MY application sends XML requests to a perl script, which has to
parse them and turn them into queries which get sent off, then the
results are put back into XML, and sent back to the client.
This doesn't answer your
On Tue, 28 Mar 2006 12:14:28 +1000 Klint Gore [EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006 10:10:15 +0930 (CST), Michael Talbot-Wilson [EMAIL
PROTECTED] wrote:
How, really, do people pronounce PostgreSQL?
we just use postgres.
Post Gress is what I've heard also.
They say that SQL
Many of my tables have a timestamp column, which I store as
TIMESTAMP WITH TIME ZONE. Often I only want to return the date from
this field, and it may need a specific format.
All of the queries are passed through PLpqsql functions that return
either a record or a set of records. I find if I
On Tue, Mar 28, 2006 at 03:34:18PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] writes:
but that syntax doesn't work. I thought I might be able to create
my own type, and have an implicit conversion of DATE,
You can *make* an implicit cast from (or to) DATE, but there won't be
one made for
SunWuKung [EMAIL PROTECTED] wrote:
I have a table in which I am storing parameters that I would like to use
as variables in a pgsql procedure.
Currently I find no other way to refer to these than to assign each
record to a variable by a separate query like this:
I'm not sure if you are
On Wed, Mar 15, 2006 at 09:52:48AM -0500, Tom Lane wrote:
[EMAIL PROTECTED] writes:
I've been unable to come up with the counterpart to select the
keywords and populate an array that I can return..
I think you want something along the lines of
kwlist := array(select keyword from
On Wed, Mar 15, 2006 at 09:36:04AM -0700, Brendan Duddridge wrote:
Hi,
Is it possible to put an index on an array column?
Apparently yes (I just did it as a test). However, consider the
following from the manual.
Tip: Arrays are not sets; searching for specific array elements
may be
Hi
I'm new to Postgres, but I've been having fun with it. In our
application we want to be able to store a variable number of
keywords for a record.
I first thought that an array column would be the way to go, but
after reading caveats on performance, I implemented they keywords
as a separate
