In trying to use a plpgsql stored proc, I'm getting an error I don't
understand.
When the select at the bottom of this email is executed, I'm getting the
message:
ERROR: parser: parse error at or near "$1"
Any ideas?
--
Ken Corey, CTOAtomic Interactive, Ltd.
select 'drop FUNCTION IU_
Ken Corey <[EMAIL PROTECTED]> writes:
> When the select at the bottom of this email is executed, I'm getting the
> message:
> ERROR: parser: parse error at or near "$1"
I don't get that; I get
ERROR: Attribute 'username_in' not found
which is about what I'd expect for the given functio
Wow! Answering emails on a Sunday? Someone should be giving you an award or
something.
On Sunday 04 February 2001 8:13 pm, you wrote:
> Ken Corey <[EMAIL PROTECTED]> writes:
> > When the select at the bottom of this email is executed, I'm getting the
> > message:
> > ERROR: parser: parse erro
Tom, Ken,
> There should be a more direct way of doing this, but for
> now, the
> postmaster logfile is the best recourse ...
>
> regards, tom lane
I've also found that if, when debugging, you launch
postmaster from a kconsole and leave the process running in
the foregroun
Hi all,
I have a problem using aggregate function SUM() ...
The platform is PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc
2.7.2.1 .
The story is that I need to join two tables with an aggregate function.
Here is a sample model :
Table A consist of ( fa1 , fa2 )
Table B consist of
Tom,
What's the syntax for directional joins in 7.1 beta?
Thanks!
-Josh Berkus
__AGLIO DATABASE SOLUTIONS___
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565
Tom,
Sorry! Never mind, I found it in the Development Docs.
Grazie!
-Josh
__AGLIO DATABASE SOLUTIONS___
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and
Tom, Stephen,
I'm trying to parse a query like the following and keep
getting various errors (I'd give you the real query but
&%^$# Netscape won't do cut-and-paste):
SELECT a.1, b.2, c.14, a.2, c.5
FROM a INNER JOIN b ON a.1=b.3
LEFT OUTER JOIN c on a.1=c.2;
And I get:
ERROR: JO
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> And I get:
> ERROR: JOIN/ON CLAUSE REFERS TO 'c' WHICH IS NOT PART OF
> JOIN.
> What's wrong here?
I don't believe you transcribed your query accurately.
My attempt to replicate the complaint works fine:
nic=# create table a (one int, two int);
CREATE
> On Sat, 3 Feb 2001, Tom Lane wrote:
>
> > I get
> >
> > regression=# SELECT * FROM orders;
> > order_id | menu_id | price
> > --+-+---
> > 1 | 2 |-1
> > (1 row)
> >
> > which is the correct result given that rules are executed before the
> > original query
"omid omoomi" <[EMAIL PROTECTED]> writes:
> The platform is PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc
> 2.7.2.1 .
> I want to write a query which looks like this :
> select fa1 - sum(fc3)
> from A,B,C
> where fa1=fb1 and fb2=fc2
> group by fa1 ;
> unfortunately I get this in r
> HI, All!
>
> How can I try
>
> set abc {5,6,7,8}
> return abc{0} # return 5
>
> pltcl
>
> thanks
12 matches
Mail list logo
