Re: Missing rows in resultset

From: björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Missing rows in resultset
Date: 2010-08-30 13:50:54
Message-ID: 6f6737bd-2650-4e91-a5ff-aaf30d6c91e9@h19g2000yqb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30 Aug, 00:02, björn lundin <b(dot)f(dot)lun(dot)(dot)(dot)(at)gmail(dot)com> wrote:

> Or is it just beeing late, and me being blind?
> eyetv=# select * from programmes where title like 'Star*';

It was of course me being blind...

select * from programmes where title like 'Star%';
is the correct way.
Wrong wildcard character '%' instead of '*'
Sorry for the noise

/Björn

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2010-08-30 14:05:12 Re: Question on trigger data visibility
Previous Message George Woodring 2010-08-30 12:17:56 Database corruption