Postgres Pro
Downloads
Home   >   mailing lists

[pgsql-students] select works and not. - Mailing list pgsql-students

From Gonzalo V
Subject [pgsql-students] select works and not.
Date
Msg-id CAF40P_3_XTbSszjrsaVP-wbpHArAsaomshRqSR7x1PipfH9pig@mail.gmail.com
Whole thread Raw
Responses Re: [pgsql-students] select works and not.
List pgsql-students
Tree view
Good day
please i need help on this search, i am stuck by days!

select * from ventasprueba v 
where v."DIRECCION" like 'AVDA. LA DEHESA  #1445, LOCAL 1031, LO BARNECHEA'
it gives me nothing.
but if i delete ,LO BARNECHEA

 select * from ventasprueba v 
where v."DIRECCION" like 'AVDA. LA DEHESA  #1445, LOCAL 1031%'
it works!.
i need to make that select with the complete string but it doesnt work.
can you help me


Saludos,
Gonzalo

pgsql-students by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [pgsql-students] [HACKERS] [GSoC] Push-based query executor discussion
Next
From: "Kevin+ Martyn"
Date:
Subject: Re: [pgsql-students] select works and not.