Home > mailing lists

type conversions - Mailing list pgsql-sql

From	sad
Subject	type conversions
Date	April 15, 2004 04:59:01
Msg-id	200404150804.42666.sad@bankir.ru Whole thread Raw
In response to	SET idiom in insert statement (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List	pgsql-sql

hi

SELECT 'tbl'::regclass;
works fine

SELECT 'tbl'::text::regclass;
says cannot convert type text to regclass

what to do ?

From: Kenneth Gonsalves
Date: 15 April 2004, 01:40:06
Subject: SET idiom in insert statement

From: "kumar"
Date: 15 April 2004, 06:57:38
Subject: Grant permission to all objects of user A to user B