Tom, Jan,
After spending an entire day writing and debugging a
particularly complex PLPGSQL function, I just received this
error:
Procedures Cannot Take More than 16 Arguments.
This is a truly devastating blow to my application (which
is already behind schedule, needless to say)
Tom,
> > Hmmm thinking about it logically, shouldn't the database engine be
> > able to use an index on a single column either backwards or forwards?
>
> Sure, but he wanted a sort with the first column in ascending order and
> the second in descending order. You can't get that by scanning
"Kim Yunhan" <[EMAIL PROTECTED]> writes:
> then, how to make operator class?
See the Programmer's Guide, particularly
http://www.postgresql.org/devel-corner/docs/postgres/xindex.htm
If this is a followup to your previous question about making a
reverse-order index, you'll need to start by making
On Thu, Feb 08, 2001 at 05:28:59PM -0500, Jelle Ouwerkerk wrote:
> Hi,
>
> How might I insert a new row into a table and return the id of the new row
> all in the same SQL statement? The id is generated by a sequence. Up to
> now I've been getting the nextval of the sequence first and then insert
when create indexes, use operator class like this.
CREATE INDEX idx_name ON tbl_name (col_name [operator class]);
so, i made an operator.
but i think that it is different operator class because operator class doesn't work at
all.
then, how to make operator class?
mark proctor <[EMAIL PROTECTED]> writes:
> However if I put the PERFORM line back in to create a recursive
> function it just goes on forever, and I only have 6 nodes.
Hm. There may be a bug here, or maybe you're still confused... but I'm
not eager to reverse-engineer your table declarations an
