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 yo
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 simple,
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 mad
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 d
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
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 y
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 b
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 keyw
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 t
