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
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
Check my SQL Code-
select u.uid, count(n.nid) nc , count(c.cid) cc from users u left join
node n on ( n.uid = u.uid ) left join comments c on ( c.uid = u.uid )
group by u.uid having u.uid
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
I need to test each record of a cursor for some requirements, something like thisDECLARE xpvnr varchar(50); xdata date; xcod int; xagentd varchar(3); xid bigint; xserie varchar(4); xnr varchar(7); xsocasig varchar(3); DECLARE myCursor CURSOR FOR
> 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
t, 8 Nov 2003 06:02:15 + (GMT)
> From: "[iso-8859-1] ron_tabada" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: [SQL] help me...
>
> Hello everyone, Good day! Could anyone help me translate this query in Microsoft
> Acces
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
859-1] ron_tabada wrote:
> Date: Sat, 8 Nov 2003 06:02:15 + (GMT)
> From: "[iso-8859-1] ron_tabada" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: [SQL] help me...
>
> Hello everyone, Good day! Could anyone help me translate th
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 SumOfqtyFROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemnoGROUP BY items.descript
Where can i find a tutorial on PL/PGSQL?.Help me by
listing some sites to guide me in this context.
Thanks.
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---(end of broadcast)
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
Hello
I cannot write new function with local variables
(see image in attachment).
That I do wrong?
Best regards,Yaroslav Ulyanov[EMAIL PROTECTED]
<>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
How to convert charter varying type to integer while retrieving
the value using ITL tag [query]?!
___
Click below to experience Sooraj R Barjatya's latest offering
'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek
& Kareena http://www.mpkdh.com
15 matches
Mail list logo
