Postgres Pro
Downloads
Home   >   mailing lists

type regclass casting - Mailing list pgsql-sql

From sad
Subject type regclass casting
Date
Msg-id 200405311152.42932.sad@bankir.ru
Whole thread Raw
In response to passing new/old record in pl/pgsql trigger functions to other functions  (basic <basic@mozdev.org>)
List pgsql-sql
Tree view 
hello

look

select * from pg_class where oid = 'sometablename'::regclass;
(1 row)

select * from pg_class where oid = 'sometablename'::text::regclass;
ERROR  can not cast TEXT to regclass

What does this mean ?

version 7.3.3
please try it on 7.4.x

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: passing new/old record in pl/pgsql trigger functions to other functions
Next
From: "Jaime Casanova"
Date:
Subject: joining a table with a function