In response to Nilesh Govindarajan :
> Hi,
>
> I want to find out the userid, nodecount and comment count of the userid.
>
> I'm going wrong somewhere.
>
> Check my SQL Code-
Check my example:
test=*# select * from u;
id
1
2
3
(3 rows)
test=*# select * from n;
uid
-
1
1
Calin Meze wrote:
I need to test each record of a cursor for some requirements,
something like this
[snip]
-- the problem is that I do not know how to make the while loop
execute until the last record "WHILE (still in the cursor)"... So I
need something like
Can anyone help me with this? It
> Where can i find a tutorial on PL/PGSQL?.Help me by
> listing some sites to guide me in this context.
Does the following meet your needs?
Chapter 19. PL/pgSQL - SQL Procedural Language
http://www.sql.org/sql-database/postgresql/manual/plpgsql.html
--
Ra
Hi,
I'm usually wrong, but you can create a view for Query1 and Query2. That
is do
create view Query1 [your query for query1];
create view Query2 [your query for query2];
Then what you are doing should work.
Regards,
Yasir
On Sat, 8 Nov 2003, [iso-8859-1] ron_tabada wrote:
> Date: Sat, 8 Nov 20
That's what I said! :)
Yasir
On Sun, 9 Nov 2003, Christopher Browne wrote:
> Date: Sun, 09 Nov 2003 21:59:14 -0500
> From: Christopher Browne <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: [SQL] help me...
>
> The world rejoiced as [EMAIL PROTECTED]
The world rejoiced as [EMAIL PROTECTED] (ron_tabada) wrote:
> Hello everyone, Good day! Could anyone help me translate this query
> in Microsoft Access to Postgresql. I'm having a difficulty. Pls...
>
> Query1:
> SELECT items.description, Sum(supplieditems.qty) AS SumOfqty
> FROM items INNER JOIN s
Hi,
I'm usually wrong, but you can create a view for Query1 and Query2. That
is do
create view Query1 [your query for query1];
create view Query2 [your query for query2];
Then what you are doing should work. Are views offered in Access?
Regards,
Yasir
On Sat, 8 Nov 2003, [iso-8859-1] ron_tabada
Very thanks, George!
- Original Message -
From:
George Weaver
To: Yaroslav Ulyanov ; [EMAIL PROTECTED]
Sent: Friday, September 05, 2003 12:48
AM
Subject: Re: [SQL] Help me
Hi Yaroslav,
You must set the language as:
LANGUAGE 'pl
Hi Yaroslav,
You must set the language as:
LANGUAGE 'plpgsql';
Regards,
George
- Original Message -
From:
Yaroslav Ulyanov
To: [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 2:46
AM
Subject: [SQL] Help me
Hello
I cannot write new functio
