Add hint for function named "is"

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Add hint for function named "is"
Дата
Msg-id 99ad0450-b1ab-702f-48ef-6972b630bc87@BlueTreble.com
обсуждение исходный текст
Ответы Re: Add hint for function named "is"  ("David E. Wheeler" <david@justatheory.com>)
Список pgsql-hackers
CREATE FUNCTION pg_temp.is() RETURNS text LANGUAGE sql AS $$SELECT 
'x'::text$$;
SELECT 'x'||is();
ERROR:  syntax error at or near "("
LINE 1: SELECT 'x'||is();

I was finally able to figure out this was because "is" needs to be 
quoted; is there a way this could be hinted?

FWIW, the real-world case here comes from using pgTap, which has an is() 
function. I've used that countless times by itself without quoting, so 
it never occurred to me that the syntax error was due to lack of quotes.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: money type overflow checks
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Small issues in syncrep.c