On Sunday, August 29, 2010, björn lundin wrote:
> eyetv=# select * from programmes where title like 'Star*';
* isn't the SQL wildcard character. % is.
--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."
--
Sent via pgsql-general mail
I got a table holding tv air time but I got a unexpected (to me)
behaviour.
Using like, I do not get the recordset I'd like.
I've installed it using mac-ports on an old mac-mini, ppc
I'd expect to see the same rows with wildcard, as I see without, see
below
Or is it just beeing late, and me bein
On 30 Aug, 00:02, björn lundin 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
