Re: [SQL] Character type name?? How to lower case it? - Mailing list pgsql-sql

> Moin!
>
> On Fri, 29 Jan 1999 09:43:33 +0100 (MET)
>     Remigiusz Sokolowski <rems@gdansk.sprint.pl> wrote:
> > >
> > > I have this script:
> > >       SELECT a.attname, t.typname, a.attlen
> > >         FROM pg_class c, pg_attribute a, pg_type t
> > >           WHERE c.relname = 'regis' and a.attname in
> > > ('var1','var2',var3');
> > >
> > > but a.attname is of type name, inwhich text(..) or lower(..)
> > > do not work with this type and I do not seem to be able to
> > > convert type name to text....
> > >
> > > Can someone help me get around this?
> > >
> >
> > You could use case-insensitive regex operator - Your query should looks
> > like following:
> >     SELECT a.attname, t.typname, a.attlen
> >         FROM pg_class c, pg_attribute a, pg_type t
> >         WHERE c.relname = 'regis' and (a.attname ~*'var1' OR
> > a.attname~*'var2' OR a.attname~*'var3');
>
> Why not
> [...]
>   WHERE c.relname = 'regis' and a.attname ~* 'var[1-3]'
> [...]
>
> It's a regex, remember?
> The OR isn't necessary.

Right, but I suppose, that var1 and var2 and var3 are only examples - it
could be that it would be 'chicks', 'flames' and 'tails' - what about
this? :-)
    rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------