Re: Operator is not unique

[PegoraroF10 <marcos@xxxxxxxxxx>]

your select returns no records but if I use 
WHERE p.proname ~ 'day_inc'
instead of 
WHERE p.proname OPERATOR(pg_catalog.~) '^(pg_catalog.day_inc)$'


  	Schema
  	Name
  	Result data type
  	Argument data types
  	Type


  	pg_catalog
  	day_inc
  	anyelement
  	adate anyelement, ndays numeric
  	func


  	pg_catalog
  	day_inc
  	anyelement
  	ndays numeric, adate anyelement
  	func






--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html