Re: bytea question

thanks anyway but that doesn't work.  i should've mentioned that i'd
already tried that in SQL.  my apologies.


tig4=# \d x
          Table "x"
 Attribute | Type  | Modifier
-----------+-------+----------
 tgargs    | bytea |

tig4=# select substr(tgargs,1,5) from x;
ERROR:  Function 'substr(bytea, int4, int4)' does not exist
 Unable to identify a function that satisfies the given argument types
 You may need to add explicit typecasts

tig4=# select substr(tgargs::text,1,5) from x;
ERROR:  Cannot cast type 'bytea' to 'text'

and other things like varchar, etc.

tig4=# select * from x;
                                    tgargs
------------------------------------------------------------------------------
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000

what i'm looking to do here is to get the table names and column names out
using sql.  i can do it in perl with a split command on '\' but was curious
as to how to "SQL" split up a BYTEA type field.

mikeo


At 04:38 PM 8/15/00 -0400, mjp@ornl.gov wrote:
>Try
>
>substr(text,int4) or
>substr(text, int4, int4)
>
>For example,
>
>
>% select substr('hi there',4,3);
> substr
>--------
> the
>(1 row)
>
>Morey Parang
>ORNL