Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Can not match 0 on bytea
- From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
- To: seiliki(at)so-net(dot)net(dot)tw
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Can not match 0 on bytea
- Date: Sat, 27 Feb 2010 10:34:42 +0100
- Message-id: <ae93099e-58c3-4251-868d-89f27d250678@mm> <text/plain>
seiliki(at)so-net(dot)net(dot)tw wrote: > Data type of table1.c1 is bytea. That column stores binary data. The > following matchings do not work. What is the right syntax? > > TIA > CN > --------------- > select c1 ~ E'\000' from table1; > select c1 LIKE E'%\000%' from table1; selection position(E'\\000'::bytea in c1) from table1; The value is 0 when there is no match and >0 otherwise. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
- References:
- Can not match 0 on bytea
- From: seiliki
- Can not match 0 on bytea
- Prev by Date: Re: ERROR: value out of range: underflow
- Next by Date: Re: regexp_replace: LF, CR, or tab
- Previous by thread: Can not match 0 on bytea
- Next by thread: Re: Can not match 0 on bytea
- Indexes: