Search Postgresql Archives

Re: Missing rows in resultset

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 30 Aug, 00:02, björn lundin <b.f.lun...@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux