pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsql query
18+ messages / 16 participants
[nested] [flat]
* sql query
@ 2001-02-08 04:57 manjul katare <manjulkatare@hotmail.com>
0 siblings, 0 replies; 18+ messages in thread
From: manjul katare @ 2001-02-08 04:57 UTC (permalink / raw)
To: pgsql-sql
sir ,
kindly send me the solution of the above query.
1.
To calculate th no. of days between 01/01/2000 to 03/02/2001.
2.
TO calculate th time in newfoundland from centra standard time from
02-22-97 ,05.00 am.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
^ permalink raw reply [nested|flat] 18+ messages in thread
* SQL Query
@ 2001-09-11 08:41 Miguel González <iafmgc@unileon.es>
2001-09-11 12:52 ` Re: SQL Query Adam Lang <aalang@rutgersinsurance.com>
0 siblings, 1 reply; 18+ messages in thread
From: Miguel González @ 2001-09-11 08:41 UTC (permalink / raw)
To: pgsql-sql; +Cc: PostgreSQL PHP <pgsql-php@postgresql.org>
Dear all,
I want to do a query to my PostgreSQL database. I want to use it in a PHP web client that I have got, but also
I have tried in the back-end.
I have the following tables on my database ( I translate the field names from Spanish into English)
cdroms
-------
code_cdroms
items
-----
code_items
description
cdroms_items
-------------
code_cdroms
code_items
loans
----------
code_loan
reservations
--------
code_reservation
The Query I want to execute is to search the cdroms that contains an item with the description provided by a form by the user.
That query works fine, it is just a simple join among cdroms, items and cdroms_items.
My problem shows up when I want to create two new fields to show whether the cdrom is on loan or is booked (someone made a reservation).
After reading some books and web sites, I concluded to use the CASE statement ( I do not know if there is any other alternative). I tried it, and it
worked, but only in the case there is any register in the loans or reservations tables, if there is not, the back-end says that you are trying to get more
than 200 registers. What am I doing wrong? Here you have the SQL query. I translated the name of the fields, hope there is no mistake.
I search for a string 'net' in the description field of the items table:
SELECT
cdroms.code_cdroms,cdroms_etiqueta,items.description,loans.code_loans,
loans.tabletype,reservations.code_reservations,reservations.tabletype,
(case
when
cdroms.code_cdroms=cdroms_items.code_cdroms
and cdroms.code_cdroms=code_prestamo
and cdroms_items.code_items=items.code_items
and items.description like %net%
then 'Yes' else 'No'
end)
as onloan,
(case
when
cdroms.code_cdroms=cdroms_items.code_cdroms
and cdroms.code_cdroms=code_loans
and cdroms.code_cdroms= ANY (select code_reservations from
reservations)
and cdroms_items.code_items=items.code_items
and items.description like %net%
then 'Yes' else 'No'
end)
as booked
from cdroms,items,cdroms_items,loans,reservations
where
cdroms.code_cdroms=cdroms_items.code_cdroms
and loans.tabletype='cdroms'
and cdroms_items.code_items=items.code_items
and items.description like '%net%';
Sorry for my English. Hope you can understand. Is is a problem of concept or a sintax problem?
Many thanks in advance
Regards
Miguel
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL Query
2001-09-11 08:41 SQL Query Miguel González <iafmgc@unileon.es>
@ 2001-09-11 12:52 ` Adam Lang <aalang@rutgersinsurance.com>
2001-09-12 07:51 ` Re: SQL Query Miguel González <iafmgc@unileon.es>
0 siblings, 1 reply; 18+ messages in thread
From: Adam Lang @ 2001-09-11 12:52 UTC (permalink / raw)
To: ; +Cc: PostgreSQL PHP <pgsql-php@postgresql.org>
If you could give the table layouts a little bit better, I may be able to
help. I can't quite tell what the table names are and what the fields are.
As a preliminary guess, it almost looks like you don't have fields in the
other tables to properly link thedata... but again I can't tell for sure.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Miguel González" <iafmgc@unileon.es>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL Query
2001-09-11 08:41 SQL Query Miguel González <iafmgc@unileon.es>
2001-09-11 12:52 ` Re: SQL Query Adam Lang <aalang@rutgersinsurance.com>
@ 2001-09-12 07:51 ` Miguel González <iafmgc@unileon.es>
0 siblings, 0 replies; 18+ messages in thread
From: Miguel González @ 2001-09-12 07:51 UTC (permalink / raw)
To: Adam Lang <aalang@rutgersinsurance.com>; +Cc: PostgreSQL PHP <pgsql-php@postgresql.org>; pgsql-sql
Sorry If i didnt make clear which are the fields and which are the tables.
The tables are the ones "underlined", so I have cdroms, items, cdroms_items,
loans and reservations. I just left the important
fields in order not to confuse the people, and just wrote the name of the
fields that are the primary keys and also the foreign keys.
An item can be in different cdroms, and a cdrom can have different items,
thats why i have the table cdroms_items for the n to n relation. I forgot to
put the name of some fields when I translated into English, I am sorry about
it. In the tables loans and reservations i added a field called typetable, a
string where i store wich kind of object is loaned or booked, this is
because I also have a hardware table, where i store names of different
hardware that also could be loaned or booked. The idea is that the loanable
and bookable objets and therefore the number of tables will be increased
(books,magazines, etc).
I reviewed the query and i noticed that I didnt translate well some names,
sorry again. Hope that now you can help me out, i am getting close to the
dateline.
Many thanks Miguel
---------------- Reviewed information ----------------------------
In loans i
cdroms
-------
code_cdroms
label
items
-----
code_items
description
cdroms_items
-------------
code_cdroms
code_items
loans
----------
code_loan
typetable
reservations
--------
code_reservation
typetable
SELECT
cdroms.code_cdroms,cdroms_label,items.description,loans.code_loans,
loans.tabletype,reservations.code_reservations,reservations.tabletype,
(case
when
cdroms.code_cdroms=cdroms_items.code_cdroms
and cdroms.code_cdroms=code_loan
and cdroms_items.code_items=items.code_items
and items.description like %net%
then 'Yes' else 'No'
end)
as onloan,
(case
when
cdroms.code_cdroms=cdroms_items.code_cdroms
and cdroms.code_cdroms=code_loan
and cdroms.code_cdroms= ANY (select code_reservations from
reservations)
and cdroms_items.code_items=items.code_items
and items.description like %net%
then 'Yes' else 'No'
end)
as booked
from cdroms,items,cdroms_items,loans,reservations
where
cdroms.code_cdroms=cdroms_items.code_cdroms
and loans.tabletype='cdroms'
and cdroms_items.code_items=items.code_items
and items.description like '%net%';
----- Original Message -----
From: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "PostgreSQL PHP" <pgsql-php@postgresql.org>
Sent: Tuesday, September 11, 2001 2:52 PM
Subject: Re: [PHP] SQL Query
> If you could give the table layouts a little bit better, I may be able to
> help. I can't quite tell what the table names are and what the fields
are.
>
> As a preliminary guess, it almost looks like you don't have fields in the
> other tables to properly link thedata... but again I can't tell for sure.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
> ----- Original Message -----
> From: "Miguel González" <iafmgc@unileon.es>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* SQL QUERY
@ 2002-12-03 12:43 Pedro Igor <pedroigor@aip.com.br>
2002-12-03 13:05 ` Re: SQL QUERY Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 18+ messages in thread
From: Pedro Igor @ 2002-12-03 12:43 UTC (permalink / raw)
To: pgsql-sql
I have the following function:
CREATE FUNCTION public.auto_incremento() RETURNS trigger AS '
begin
new.id = (select (max(id) + 1) from teste);
return new;
end;' LANGUAGE 'plpgsql'
I created a trigger that uses this function, but i want to the function be usefull for all tables and not only to tbale teste.
Someone know how ???
Pedro Igor
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL QUERY
2002-12-03 12:43 SQL QUERY Pedro Igor <pedroigor@aip.com.br>
@ 2002-12-03 13:05 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 18+ messages in thread
From: Achilleus Mantzios @ 2002-12-03 13:05 UTC (permalink / raw)
To: Pedro Igor <pedroigor@aip.com.br>; +Cc: pgsql-sql
On Tue, 3 Dec 2002, Pedro Igor wrote:
> I have the following function:
> CREATE FUNCTION public.auto_incremento() RETURNS trigger AS '
> begin
> new.id = (select (max(id) + 1) from teste);
> return new;
> end;' LANGUAGE 'plpgsql'
>
> I created a trigger that uses this function, but i want to the function be usefull for all tables and not only to tbale teste.
>
> Someone know how ???
Take a look at sequences.
(In Addition, they are autimatically created when a column is of type
'SERIAL').
>
>
>
> Pedro Igor
>
>
>
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL QUERY
@ 2002-12-03 14:47 Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 18+ messages in thread
From: Achilleus Mantzios @ 2002-12-03 14:47 UTC (permalink / raw)
To: Pedro Igor <pedroigor@aip.com.br>; +Cc: pgsql-sql
On Tue, 3 Dec 2002, Pedro Igor wrote:
> But i want implement a trigger that auto-increments the id field. This
> options is personal, i don´t like to depend from the database.
>
Then use table name as parameter to your function.
But trully its an error prone policy the one you try to follow,
what if a table has a primary key named "fobarid"??
Your function will not work correctly.
Or you could programatically read the system tables
and find out which column is the primary key for a given table.
But unfortunately that way you depend on the database
even worse than simply and nicely use sequences.
> Pedro Igor
>
> ----- Original Message -----
> From: "Achilleus Mantzios" <achill@matrix.gatewaynet.com>
> To: "Pedro Igor" <pedroigor@aip.com.br>
> Cc: <pgsql-sql@postgresql.org>
> Sent: Tuesday, December 03, 2002 11:05 AM
> Subject: Re: [SQL] SQL QUERY
>
>
> > On Tue, 3 Dec 2002, Pedro Igor wrote:
> >
> > > I have the following function:
> > > CREATE FUNCTION public.auto_incremento() RETURNS trigger AS '
> > > begin
> > > new.id = (select (max(id) + 1) from teste);
> > > return new;
> > > end;' LANGUAGE 'plpgsql'
> > >
> > > I created a trigger that uses this function, but i want to the function
> be usefull for all tables and not only to tbale teste.
> > >
> > > Someone know how ???
> >
> > Take a look at sequences.
> > (In Addition, they are autimatically created when a column is of type
> > 'SERIAL').
> >
> > >
> > >
> > >
> > > Pedro Igor
> > >
> > >
> > >
> > >
> >
> > ==================================================================
> > Achilleus Mantzios
> > S/W Engineer
> > IT dept
> > Dynacom Tankers Mngmt
> > Nikis 4, Glyfada
> > Athens 16610
> > Greece
> > tel: +30-10-8981112
> > fax: +30-10-8981877
> > email: achill@matrix.gatewaynet.com
> > mantzios@softlab.ece.ntua.gr
>
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 18+ messages in thread
* sql query
@ 2002-12-04 02:03 Vijay Uppal <vijay25@telus.com>
0 siblings, 0 replies; 18+ messages in thread
From: Vijay Uppal @ 2002-12-04 02:03 UTC (permalink / raw)
To: pgsql-sql
Hi I have a problem forming a query
I have 3 tables salary(hrs, clock_in , clock_out)
Break ( date, employe_id, net_time, break_in, break_out)
Employee(employee_id, pay_rate, name)
I need to get an hourly report till the current time for that day
stating name, hour, no of hours, salary
Example
Rob 3-4 48min $6.56
Min 2-3 23min $2.34
Min 3-4 54min $7.67
And so on..Would appreciate help on this.since I cant come up with the
query
Vj
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: sql query
@ 2002-12-11 09:06 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 18+ messages in thread
From: Christoph Haller @ 2002-12-11 09:06 UTC (permalink / raw)
To: vijay25@telus.com; +Cc: pgsql-sql
>
> Hi I have a problem forming a query
> I have 3 tables salary(hrs, clock_in , clock_out)
> Break ( date, employe_id, net_time, break_in, break_out)
> Employee(employee_id, pay_rate, name)
>
> I need to get an hourly report till the current time for that day
> stating name, hour, no of hours, salary
> Example
>
> Rob 3-4 48min $6.56
> Min 2-3 23min $2.34
> Min 3-4 54min $7.67
>
> And so on..Would appreciate help on this.since I cant come up with the
> query
>
How do you intend to find out which entry in your table "salary" is
related
to which employee as there is no id to refer to.
Am I right in assuming your column "hour" with entries 3-4, 2-3, ...
means from 3 til 4 o'clock and so on?
Regards, Christoph
^ permalink raw reply [nested|flat] 18+ messages in thread
* SQl query
@ 2003-05-07 08:20 Abdul Wahab Dahalan <wahab@mimos.my>
2003-05-07 08:34 ` Re: SQl query Matthew Horoschun <mhoroschun@canprint.com.au>
2003-05-07 08:57 ` Re: SQl query Victor Yegorov <viy@nordlb.lv>
2003-05-07 09:00 ` Re: SQl query DIB Walid <walid.dib@inrialpes.fr>
2003-05-07 09:21 ` Re: SQl query A.Bhuvaneswaran <bhuvansql@myrealbox.com>
0 siblings, 4 replies; 18+ messages in thread
From: Abdul Wahab Dahalan @ 2003-05-07 08:20 UTC (permalink / raw)
To: pgsql-sql
If I've a transport table like this:
transporttype | transportid
---------------+-------------
Lorry | 1037
Pickup | 1038
Lorry | 1040
Lorry | 1045
Pickup | 1046
Lorry | 1047
How do I make a query so that I get a result like
transporttype | #of transport
---------------+-------------
Lorry | 4
Pickup | 2
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQl query
2003-05-07 08:20 SQl query Abdul Wahab Dahalan <wahab@mimos.my>
@ 2003-05-07 08:34 ` Matthew Horoschun <mhoroschun@canprint.com.au>
3 siblings, 0 replies; 18+ messages in thread
From: Matthew Horoschun @ 2003-05-07 08:34 UTC (permalink / raw)
To: wahab@mimos.my; +Cc: pgsql-sql
Hi Abdul,
> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2
SELECT transporttype, count(*) FROM transport GROUP BY transporttype;
Cheers
Matthew.
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQl query
2003-05-07 08:20 SQl query Abdul Wahab Dahalan <wahab@mimos.my>
@ 2003-05-07 08:57 ` Victor Yegorov <viy@nordlb.lv>
3 siblings, 0 replies; 18+ messages in thread
From: Victor Yegorov @ 2003-05-07 08:57 UTC (permalink / raw)
To: Abdul Wahab Dahalan <wahab@mimos.my>; +Cc: pgsql-sql
* Abdul Wahab Dahalan <wahab@mimos.my> [07.05.2003 11:52]:
> If I've a transport table like this:
> transporttype | transportid
> ---------------+-------------
> Lorry | 1037
> Pickup | 1038
> Lorry | 1040
> Lorry | 1045
> Pickup | 1046
> Lorry | 1047
>
> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2
select
transporttype,
count(transporttype)
from
your_table
group by
transporttype;
--
Victor Yegorov
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQl query
2003-05-07 08:20 SQl query Abdul Wahab Dahalan <wahab@mimos.my>
@ 2003-05-07 09:00 ` DIB Walid <walid.dib@inrialpes.fr>
3 siblings, 0 replies; 18+ messages in thread
From: DIB Walid @ 2003-05-07 09:00 UTC (permalink / raw)
To: wahab@mimos.my; +Cc: pgsql-sql
Hello,
here is a suggestio:
select transporttype, count(transportid) as number of transport
from transport
group by transporttype;
@+
Walid
Le Mercredi 7 Mai 2003 10:20, vous avez écrit :
> If I've a transport table like this:
> transporttype | transportid
> ---------------+-------------
> Lorry | 1037
> Pickup | 1038
> Lorry | 1040
> Lorry | 1045
> Pickup | 1046
> Lorry | 1047
>
> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQl query
2003-05-07 08:20 SQl query Abdul Wahab Dahalan <wahab@mimos.my>
@ 2003-05-07 09:21 ` A.Bhuvaneswaran <bhuvansql@myrealbox.com>
3 siblings, 0 replies; 18+ messages in thread
From: A.Bhuvaneswaran @ 2003-05-07 09:21 UTC (permalink / raw)
To: Abdul Wahab Dahalan <wahab@mimos.my>; +Cc: pgsql-sql
> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2
=> select transporttype, count(transporttype) as "#of transport" from
transport group by 1;
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 18+ messages in thread
* SQL query
@ 2004-02-02 15:10 Paul Czubilinski <pawel@deso.pl>
2004-02-04 07:43 ` Re: SQL query daq <daq@ugyvitelszolgaltato.hu>
0 siblings, 1 reply; 18+ messages in thread
From: pawel@deso.pl @ 2004-02-02 15:10 UTC (permalink / raw)
To: pgsql-sql
Hello,
I would like to retrieve all the records from table A which have given
lang_id and its modification date is later then modification date of
the same id record with lang_id='pl'.
Example:
table A - data example
======================
id | modification_date | lang_id
--------+---------------------+------
abc | 2002-10-11 10:12:11 | en
abc | 2002-11-12 11:12:11 | pl
abc | 2002-11-11 18:12:00 | de
sample | 2003-04-15 22:43:14 | pl
sample | 2003-05-16 11:10:15 | en
sample | 2003-11-11 18:11:10 | de
If given lang_id would be 'en' the following record should be choosed:
sample | 2003-05-16 11:10:15 | en
(it has mofication date later then record with id = sample and lang_id
= pl)
If you have any idea how to make SQL query for this, please help me.
Thanx,
Paul Czubilinski
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL query
2004-02-02 15:10 SQL query Paul Czubilinski <pawel@deso.pl>
@ 2004-02-04 07:43 ` daq <daq@ugyvitelszolgaltato.hu>
0 siblings, 0 replies; 18+ messages in thread
From: daq @ 2004-02-04 07:43 UTC (permalink / raw)
To: pawel@deso.pl; +Cc: pgsql-sql
PC> Hello,
PC> I would like to retrieve all the records from table A which have given
PC> lang_id and its modification date is later then modification date of
PC> the same id record with lang_id='pl'.
PC> Example:
PC> table A - data example
PC> ======================
PC> id | modification_date | lang_id
PC> --------+---------------------+------
PC> abc | 2002-10-11 10:12:11 | en
PC> abc | 2002-11-12 11:12:11 | pl
PC> abc | 2002-11-11 18:12:00 | de
PC> sample | 2003-04-15 22:43:14 | pl
PC> sample | 2003-05-16 11:10:15 | en
PC> sample | 2003-11-11 18:11:10 | de
select * from a where lang_id='en' and modification_date>(select
modification_date from a as a_alias where a_alias.id=a.id and
a_alias.lang_id='pl')
Try this!
DAQ
^ permalink raw reply [nested|flat] 18+ messages in thread
* SQL Query
@ 2004-03-23 20:02 beyaNet Consultancy <beyanet@ntlworld.com>
2004-03-23 20:46 ` Re: SQL Query Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 18+ messages in thread
From: beyaNet Consultancy @ 2004-03-23 20:02 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am trying to create a query which basically goes along the lines of:
INSERT INTO tableX ( COL1, COL2 ) VALUES ( x, y ) where COL1 !=x and
COL2 !=Y
So, insert a record into tableX where there is not already an existence
of COL1 and COL2
Can this be done as I have described or is there a more efficient way
to do this?
many thanks
Peter
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: SQL Query
2004-03-23 20:02 SQL Query beyaNet Consultancy <beyanet@ntlworld.com>
@ 2004-03-23 20:46 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 18+ messages in thread
From: Bruno Wolff III @ 2004-03-23 20:46 UTC (permalink / raw)
To: beyaNet Consultancy <beyanet@ntlworld.com>; +Cc: pgsql-sql
On Tue, Mar 23, 2004 at 20:02:32 +0000,
beyaNet Consultancy <beyanet@ntlworld.com> wrote:
> Hi,
> I am trying to create a query which basically goes along the lines of:
>
> INSERT INTO tableX ( COL1, COL2 ) VALUES ( x, y ) where COL1 !=x and
> COL2 !=Y
>
> So, insert a record into tableX where there is not already an existence
> of COL1 and COL2
>
> Can this be done as I have described or is there a more efficient way
> to do this?
>
> many thanks
>
> Peter
Pretty much the same question was asked on the admin list (though this
list is more appropiate) earlier today. The answer I gave is at:
http://archives.postgresql.org/pgsql-admin/2004-03/msg00305.php
^ permalink raw reply [nested|flat] 18+ messages in thread
end of thread, other threads:[~2004-03-23 20:46 UTC | newest]
Thread overview: 18+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-08 04:57 sql query manjul katare <manjulkatare@hotmail.com>
2001-09-11 08:41 SQL Query Miguel González <iafmgc@unileon.es>
2001-09-11 12:52 ` Re: SQL Query Adam Lang <aalang@rutgersinsurance.com>
2001-09-12 07:51 ` Re: SQL Query Miguel González <iafmgc@unileon.es>
2002-12-03 12:43 SQL QUERY Pedro Igor <pedroigor@aip.com.br>
2002-12-03 13:05 ` Re: SQL QUERY Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-12-03 14:47 Re: SQL QUERY Achilleus Mantzios <achill@matrix.gatewaynet.com>
2002-12-04 02:03 sql query Vijay Uppal <vijay25@telus.com>
2002-12-11 09:06 Re: sql query Christoph Haller <ch@rodos.fzk.de>
2003-05-07 08:20 SQl query Abdul Wahab Dahalan <wahab@mimos.my>
2003-05-07 08:34 ` Re: SQl query Matthew Horoschun <mhoroschun@canprint.com.au>
2003-05-07 08:57 ` Re: SQl query Victor Yegorov <viy@nordlb.lv>
2003-05-07 09:00 ` Re: SQl query DIB Walid <walid.dib@inrialpes.fr>
2003-05-07 09:21 ` Re: SQl query A.Bhuvaneswaran <bhuvansql@myrealbox.com>
2004-02-02 15:10 SQL query Paul Czubilinski <pawel@deso.pl>
2004-02-04 07:43 ` Re: SQL query daq <daq@ugyvitelszolgaltato.hu>
2004-03-23 20:02 SQL Query beyaNet Consultancy <beyanet@ntlworld.com>
2004-03-23 20:46 ` Re: SQL Query Bruno Wolff III <bruno@wolff.to>
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