pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp Me!!!!
12+ messages / 10 participants
[nested] [flat]
* Help Me!!!!
@ 2000-02-29 18:30 Elsa Campos <elsa_campos@usa.net>
0 siblings, 0 replies; 12+ messages in thread
From: Elsa Campos @ 2000-02-29 18:30 UTC (permalink / raw)
To: pgsql-sql; +Cc: elsa_campos@usa.net
I have a serious problem, it consists of managing the postSQL trough Perl
Language...
I do not know how can i access to the data base (postgresql)using perl
i will very grateful for your help?
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
^ permalink raw reply [nested|flat] 12+ messages in thread
* Help Me
@ 2003-07-16 01:17 Ramesh Kumar B <bramesh77@rediffmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Ramesh Kumar B @ 2003-07-16 01:17 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Help me
@ 2003-09-04 07:46 Yaroslav Ulyanov <yulyanov@mera.ru>
2003-09-04 20:48 ` Re: Help me George Weaver <georgew1@mts.net>
0 siblings, 1 reply; 12+ messages in thread
From: Yaroslav Ulyanov @ 2003-09-04 07:46 UTC (permalink / raw)
To: pgsql-sql
Hello
I cannot write new function with local variables (see image in attachment).
That I do wrong?
Best regards,
Yaroslav Ulyanov
yulyanov@mera.ru
Attachments:
untitled5.jpg (image/jpeg, 22.2K) download
view image
* Re: Help me
2003-09-04 07:46 Help me Yaroslav Ulyanov <yulyanov@mera.ru>
@ 2003-09-04 20:48 ` George Weaver <georgew1@mts.net>
2003-09-05 06:57 ` Re: Help me Yaroslav Ulyanov <yulyanov@mera.ru>
0 siblings, 1 reply; 12+ messages in thread
From: George Weaver @ 2003-09-04 20:48 UTC (permalink / raw)
To: Yaroslav Ulyanov <yulyanov@mera.ru>; pgsql-sql
Hi Yaroslav,
You must set the language as:
LANGUAGE 'plpgsql';
Regards,
George
----- Original Message -----
From: Yaroslav Ulyanov
To: pgsql-sql@postgresql.org
Sent: Thursday, September 04, 2003 2:46 AM
Subject: [SQL] Help me
Hello
I cannot write new function with local variables (see image in attachment).
That I do wrong?
Best regards,
Yaroslav Ulyanov
yulyanov@mera.ru
------------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Help me
2003-09-04 07:46 Help me Yaroslav Ulyanov <yulyanov@mera.ru>
2003-09-04 20:48 ` Re: Help me George Weaver <georgew1@mts.net>
@ 2003-09-05 06:57 ` Yaroslav Ulyanov <yulyanov@mera.ru>
0 siblings, 0 replies; 12+ messages in thread
From: Yaroslav Ulyanov @ 2003-09-05 06:57 UTC (permalink / raw)
To: George Weaver <georgew1@mts.net>; pgsql-sql
Very thanks, George!
----- Original Message -----
From: George Weaver
To: Yaroslav Ulyanov ; pgsql-sql@postgresql.org
Sent: Friday, September 05, 2003 12:48 AM
Subject: Re: [SQL] Help me
Hi Yaroslav,
You must set the language as:
LANGUAGE 'plpgsql';
Regards,
George
----- Original Message -----
From: Yaroslav Ulyanov
To: pgsql-sql@postgresql.org
Sent: Thursday, September 04, 2003 2:46 AM
Subject: [SQL] Help me
Hello
I cannot write new function with local variables (see image in attachment).
That I do wrong?
Best regards,
Yaroslav Ulyanov
yulyanov@mera.ru
----------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
^ permalink raw reply [nested|flat] 12+ messages in thread
* HELP ME
@ 2003-10-10 11:46 jagan reddy <thavvaj@yahoo.com>
2003-11-17 04:55 ` Re: HELP ME Randolf Richardson, DevNet SysOp 29 <rr@8x.ca>
0 siblings, 1 reply; 12+ messages in thread
From: jagan reddy @ 2003-10-10 11:46 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: HELP ME
2003-10-10 11:46 HELP ME jagan reddy <thavvaj@yahoo.com>
@ 2003-11-17 04:55 ` Randolf Richardson, DevNet SysOp 29 <rr@8x.ca>
0 siblings, 0 replies; 12+ messages in thread
From: Randolf Richardson, DevNet SysOp 29 @ 2003-11-17 04:55 UTC (permalink / raw)
To: pgsql-sql
> 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
--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/
This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.
^ permalink raw reply [nested|flat] 12+ messages in thread
* help me...
@ 2003-11-08 06:02 ron_tabada <ron_tabada@yahoo.com>
2003-11-09 20:53 ` Re: help me... Yasir Malik <ymalik@heineken.cs.stevens-tech.edu>
2003-11-10 02:59 ` Re: help me... Christopher Browne <cbbrowne@acm.org>
0 siblings, 2 replies; 12+ messages in thread
From: ron_tabada @ 2003-11-08 06:02 UTC (permalink / raw)
To: pgsql-sql
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 supplieditems ON items.itemno = supplieditems.itemno
GROUP BY items.description;
Query2:
SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
FROM (items INNER JOIN OtherItem ON [items].[itemno]=[OtherItem].[Itemno]) INNER JOIN customer ON [OtherItem].[Itemno]=[customer].[itemcode]
GROUP BY [items].[description];
Query3:
SELECT [Query1].[SumOfqty], [Query2].[SumOfqty], [Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
FROM Query1, Query2;
I have translated Query1 and Query2 in POSTGRESQL but I don't know how to implement Query3.
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: help me...
2003-11-08 06:02 help me... ron_tabada <ron_tabada@yahoo.com>
@ 2003-11-09 20:53 ` Yasir Malik <ymalik@heineken.cs.stevens-tech.edu>
1 sibling, 0 replies; 12+ messages in thread
From: Yasir Malik @ 2003-11-09 20:53 UTC (permalink / raw)
To: ronald@my.msuiit.edu.ph; +Cc: pgsql-sql
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 2003 06:02:15 +0000 (GMT)
> From: "[iso-8859-1] ron_tabada" <ron_tabada@yahoo.com>
> Reply-To: ronald@my.msuiit.edu.ph
> To: pgsql-sql@postgresql.org
> Subject: [SQL] help me...
>
> 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 supplieditems ON items.itemno = supplieditems.itemno
> GROUP BY items.description;
> Query2:
> SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
> FROM (items INNER JOIN OtherItem ON [items].[itemno]=[OtherItem].[Itemno]) INNER JOIN customer ON [OtherItem].[Itemno]=[customer].[itemcode]
> GROUP BY [items].[description];
> Query3:
> SELECT [Query1].[SumOfqty], [Query2].[SumOfqty], [Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
> FROM Query1, Query2;
> I have translated Query1 and Query2 in POSTGRESQL but I don't know how to implement Query3.
>
>
> ---------------------------------
> Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: help me...
2003-11-08 06:02 help me... ron_tabada <ron_tabada@yahoo.com>
@ 2003-11-10 02:59 ` Christopher Browne <cbbrowne@acm.org>
2003-11-10 13:45 ` Re: help me... Yasir Malik <ymalik@cs.stevens-tech.edu>
1 sibling, 1 reply; 12+ messages in thread
From: Christopher Browne @ 2003-11-10 02:59 UTC (permalink / raw)
To: pgsql-sql
The world rejoiced as ron_tabada@yahoo.com (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 supplieditems ON items.itemno = supplieditems.itemno
> GROUP BY items.description;
>
> Query2:
> SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
> FROM (items INNER JOIN OtherItem ON [items].[itemno]=[OtherItem].[Itemno]) INNER JOIN customer ON
> [OtherItem].[Itemno]=[customer].[itemcode]
> GROUP BY [items].[description];
>
> Query3:
> SELECT [Query1].[SumOfqty], [Query2].[SumOfqty], [Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
> FROM Query1, Query2;
>
> I have translated Query1 and Query2 in POSTGRESQL but I don't know
> how to implement Query3.
Apparently you have discovered the nearest equivalent to "VIEWs" in
Access.
I can suggest two ways:
1. Define "query1" and "query2" as PostgreSQL views, as with...
create view query1 as
SELECT items.description, Sum(supplieditems.qty) AS SumOfqty
FROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemno
GROUP BY items.description;
create view query2 as [omitted details].
Query 3 should work perfectly well when it has the two views to work
with.
2. Subselects...
SELECT Query1.SumOfqty, Query2.SumOfqty, Query1.SumOfqty-Query2.SumOfqty AS remain
FROM
(select stuff for query 1) as query1,
(select stuff for query 2) as query2;
Approach #1. seems more appropriate, as it uses the views to keep the
queries all simple.
--
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/nonrdbms.html
Incrementally extended heuristic algorithms tend inexorably toward the
incomprehensible.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: help me...
2003-11-08 06:02 help me... ron_tabada <ron_tabada@yahoo.com>
2003-11-10 02:59 ` Re: help me... Christopher Browne <cbbrowne@acm.org>
@ 2003-11-10 13:45 ` Yasir Malik <ymalik@cs.stevens-tech.edu>
0 siblings, 0 replies; 12+ messages in thread
From: Yasir Malik @ 2003-11-10 13:45 UTC (permalink / raw)
To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-sql
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 <cbbrowne@acm.org>
> To: pgsql-sql@postgresql.org
> Subject: Re: [SQL] help me...
>
> The world rejoiced as ron_tabada@yahoo.com (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 supplieditems ON items.itemno = supplieditems.itemno
> > GROUP BY items.description;
> >
> > Query2:
> > SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
> > FROM (items INNER JOIN OtherItem ON [items].[itemno]=[OtherItem].[Itemno]) INNER JOIN customer ON
> > [OtherItem].[Itemno]=[customer].[itemcode]
> > GROUP BY [items].[description];
> >
> > Query3:
> > SELECT [Query1].[SumOfqty], [Query2].[SumOfqty], [Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
> > FROM Query1, Query2;
> >
> > I have translated Query1 and Query2 in POSTGRESQL but I don't know
> > how to implement Query3.
>
> Apparently you have discovered the nearest equivalent to "VIEWs" in
> Access.
>
> I can suggest two ways:
>
> 1. Define "query1" and "query2" as PostgreSQL views, as with...
>
> create view query1 as
> SELECT items.description, Sum(supplieditems.qty) AS SumOfqty
> FROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemno
> GROUP BY items.description;
>
> create view query2 as [omitted details].
>
> Query 3 should work perfectly well when it has the two views to work
> with.
>
> 2. Subselects...
>
> SELECT Query1.SumOfqty, Query2.SumOfqty, Query1.SumOfqty-Query2.SumOfqty AS remain
> FROM
> (select stuff for query 1) as query1,
> (select stuff for query 2) as query2;
>
> Approach #1. seems more appropriate, as it uses the views to keep the
> queries all simple.
> --
> let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
> http://www.ntlug.org/~cbbrowne/nonrdbms.html
> Incrementally extended heuristic algorithms tend inexorably toward the
> incomprehensible.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: help me...
@ 2003-11-09 20:59 Yasir Malik <ymalik@cs.stevens-tech.edu>
0 siblings, 0 replies; 12+ messages in thread
From: Yasir Malik @ 2003-11-09 20:59 UTC (permalink / raw)
To: pgsql-sql
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 wrote:
> Date: Sat, 8 Nov 2003 06:02:15 +0000 (GMT)
> From: "[iso-8859-1] ron_tabada" <ron_tabada@yahoo.com>
> Reply-To: ronald@my.msuiit.edu.ph
> To: pgsql-sql@postgresql.org
> Subject: [SQL] help me...
>
> 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 supplieditems ON items.itemno =
supplieditems.itemno
> GROUP BY items.description;
> Query2:
> SELECT [items].[description], Sum([customer].[qty]) AS SumOfqty
> FROM (items INNER JOIN OtherItem ON
[items].[itemno]=[OtherItem].[Itemno]) INNER JOIN customer ON
[OtherItem].[Itemno]=[customer].[itemcode]
> GROUP BY [items].[description];
> Query3:
> SELECT [Query1].[SumOfqty], [Query2].[SumOfqty],
[Query1]![SumOfqty]-[Query2]![SumOfqty] AS remain
> FROM Query1, Query2;
> I have translated Query1 and Query2 in POSTGRESQL but I don't know how
to implement Query3.
>
>
> ---------------------------------
> Want to chat instantly with your online friends?Get the FREE
Yahoo!Messenger
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2003-11-17 04:55 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-29 18:30 Help Me!!!! Elsa Campos <elsa_campos@usa.net>
2003-07-16 01:17 Help Me Ramesh Kumar B <bramesh77@rediffmail.com>
2003-09-04 07:46 Help me Yaroslav Ulyanov <yulyanov@mera.ru>
2003-09-04 20:48 ` Re: Help me George Weaver <georgew1@mts.net>
2003-09-05 06:57 ` Re: Help me Yaroslav Ulyanov <yulyanov@mera.ru>
2003-10-10 11:46 HELP ME jagan reddy <thavvaj@yahoo.com>
2003-11-17 04:55 ` Re: HELP ME Randolf Richardson, DevNet SysOp 29 <rr@8x.ca>
2003-11-08 06:02 help me... ron_tabada <ron_tabada@yahoo.com>
2003-11-09 20:53 ` Re: help me... Yasir Malik <ymalik@heineken.cs.stevens-tech.edu>
2003-11-10 02:59 ` Re: help me... Christopher Browne <cbbrowne@acm.org>
2003-11-10 13:45 ` Re: help me... Yasir Malik <ymalik@cs.stevens-tech.edu>
2003-11-09 20:59 Re: help me... Yasir Malik <ymalik@cs.stevens-tech.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox