Re: [GENERAL] bytea question

[mjp]

Try

substr(text,int4) or
substr(text, int4, int4)

For example,


% select substr('hi there',4,3);
 substr 
--------
 the
(1 row)

Morey Parang
ORNL

On Tue, Aug 15, 2000 at 03:34:27PM -0400, mikeo wrote:
> hi all,
>    in the pg_trigger table the tgargs column is defined
> as type "BYTEA".  i can split this up in perl, once
> retrieved, but can't figure out how to "substring"
> it in sql.  is there an SQL way to select pieces of
> a column of this type?  
> 
> any help is appreciated,
> 
> mikeo