Search Postgresql Archives

Re: How to return argument data type from sql function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to return argument data type from sql function
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 14 Oct 2022 18:19:39 -0400
Cc: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to Andrus <kobruleht2@xxxxxx> message dated "Sat, 15 Oct 2022 00:48:35 +0300"
In-reply-to: <c1976464-86d4-1839-7531-f4eff3cbce64@hot.ee>
References: <86fe1ce7-3d6f-b723-b0fc-0eb796100588@hot.ee> <1185464.1665759357@sss.pgh.pa.us> <12a74d8c-58ac-f14c-39c7-3730362e08e7@hot.ee> <1417737.1665782660@sss.pgh.pa.us> <c1976464-86d4-1839-7531-f4eff3cbce64@hot.ee>

Andrus <kobruleht2@xxxxxx> writes:
> How to change this query so that it searches schemas in set search_path 
> order and returns column width from it ? In this case p_namespace 
> parameter can removed.

I showed you that already: regclass will take care of it.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- How to return argument data type from sql function
  - From: Andrus
- Re: How to return argument data type from sql function
  - From: Tom Lane
- Re: How to return argument data type from sql function
  - From: Andrus
- Re: How to return argument data type from sql function
  - From: Tom Lane
- Re: How to return argument data type from sql function
  - From: Andrus

Prev by Date: Re: How to return argument data type from sql function
Next by Date: Re: Where to flag an issue with EDB's PG15 Windows installer?
Previous by thread: Re: How to return argument data type from sql function
Next by thread: Re: How to return argument data type from sql function
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]