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

Query

From: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
To: "Postgres (pgsql-novice(at)postgresql(dot)org)" <pgsql-novice(at)postgresql(dot)org>
Subject: Query
Date: 2004-07-13 18:07:36
Message-ID: 59B41C14544D314889E6FA384A307A921C9127@osiris.insys-corp.com.mx (view raw or flat)
Thread:
Lists: pgsql-novice
Hi I have a table called "master" which look like this


id_master      |	     month    |	  day	     |   infotype
<Serial> PK  |   <Varchar 3> |  <Varchar 3>  | <Varchar 5>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
1	|	May	|  27		|	121
2	|	May	|  27		|	122
3	|	May	|  27		|	123
4	|	May	|  28		|	121
5	|	May	|  28		|	122


Which Primary Key (id_master) is the Foreign Key (id_master) of another
table called "masterdetail" which look like this

id_masterdetail	       id_master        argument         color
<Serial> PK        |   <int4>         |  <Varchar 30>  | <Varchar 10> 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
1		|	121	|  house 	| blue 
2		|	121	|  house		| blue
3		|	121	|  building	| white	
4		|	122	|  building	| white
5		|	122	|  house		| yellow


I try tu run a query to ask for all the arguments, which color has the value
"blue" and they had the date "May" "27"

I wrote something like this

select argument from masterdetail, master where color like 'blue'  
and master.month like 'May'
and master.day like '27'
and master.id_master = masterdetail.id_master;


But  I cant get the correct results!

How can I fix it?
---
Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
Insys
Soluciones Integrales de Seguridad en TI
Tel (52 55) 5322 5218 
Implantación
---

Responses

  • Re: Query at 2004-07-13 18:58:41 from Bruno Wolff III

pgsql-novice by date

Next:From: Frank BaxDate: 2004-07-13 18:23:35
Subject: Re: PostgreSQL Performance issues
Previous:From: Ullrich RalfDate: 2004-07-13 12:20:48
Subject: Seaching with and without diacritical marks

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