Skip site navigation (1) Skip section navigation (2)

question 2

From: ZioBudda <michel(at)michel(dot)enter(dot)it>
To: pgsql-general(at)postgreSQL(dot)org
Subject: question 2
Date: 1998-12-04 18:05:50
Message-ID: Pine.LNX.4.03.9812041905200.456-100000@michel.enter.it (view raw or flat)
Thread:
Lists: pgsql-general
Hi again,
I have this query :
select prestito.*, libro.tipo,libro.id_libro from prestito,libro where
prestito.id_libro =
 libro.id_libro_key
that return me (correct!):
id_libro|id_utente|data_prestito|visto|notifica1|notifica2|notifica3|tipo|id_libro
--------+---------+-------------+-----+---------+---------+---------+----+--------
      12|       37|   12-04-1998|f    |         |         |         |
1|s1      
      13|       37|   12-04-1998|f    |         |         |         |
2|k1      
(2 rows)

but if you see the item libro.id_libro is id_libro (s1,k1) and in the
prestito.*
 there is another id_libro (11,12). Now I want to know how can I select
the second "id_lib
ro".




"Il divertimento e' giusto se la scimmia ci prende gusto"
--
Italian Linux Press: http://ziobudda.enter.it/ILP/
--
Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
michel(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"


pgsql-general by date

Next:From: Petter ReinholdtsenDate: 1998-12-04 18:06:07
Subject: Re: Postgres slowdown on large tables
Previous:From: ZioBuddaDate: 1998-12-04 18:05:18
Subject: question 1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group