>As I said, that is impossible.
>
>Again, describe with many, many words what you are trying to achieve.
>There is probably a solution for the underlying problem.
>
>Yours,
>Laurenz Albe
>--
>Cybertec | https://www.cybertec-postgresql.com
Thanks all, for the responses.
On Thu, 2022-01-20 at 17:00 +, Garfield Lewis wrote:
> I need the page and possibly row of the data location to be stored as an
> element
> of the new type. This is to simulate a structure from another database system.
As I said, that is impossible.
Again, describe with many, many words what
On Thu, Jan 20, 2022 at 11:36 AM Garfield Lewis
wrote:
> The following knows there is no CTID so shouldn’t I be able to get
> something similar programmatically?
>
> [sysprog@nucky lz_pgmod] (h-master-LZRDB-4714)*$ psql -U postgres -d
> postgres -c "select ctid, 'test'"
> ERROR: column "ctid" do
On 2022-01-20, 1:11 PM, "Tom Lane" wrote:
>No, it's the same problem in reverse: the output function cannot
>know where the value came from. There is no hard and fast
>reason that it must have come out of a table, either. Consider
>something as simple as
>
> SELECT 'blah b
Garfield Lewis writes:
> I think you are right in the case of INPUT/RECEIVE, however we should be able
> to get that info during OUTPUT/SEND (I think) since it is fixed at that
> point. At the time I return the information to the user I could augment the
> output to add that information to the
> On 2022-01-20, 12:52 PM, "Tom Lane" wrote:
>
>Garfield Lewis writes:
>> I need the page and possibly row of the data location to be stored as an
> element of the new type. This is to simulate a structure from another
> database system.
>
>You need to rethink. The datatype input
Garfield Lewis writes:
> I need the page and possibly row of the data location to be stored as an
> element of the new type. This is to simulate a structure from another
> database system.
You need to rethink. The datatype input function cannot know even that
the value is going to be stored an
A CTID is a special column documented here:
https://www.postgresql.org/docs/12/ddl-system-columns.html
Regards,
Garfield
Hi Laurenz,
I need the page and possibly row of the data location to be stored as an
element of the new type. This is to simulate a structure from another database
system.
Regards,
Garfield
On Wed, Jan 19, 2022 at 1:39 PM Garfield Lewis
wrote:
>
> Hi,
>
>
>
> I am creating a new type and would like to know if it was possible to access
> the CTID for the row affected by the INPUT and RECEIVE functions of the new
> type? Actually, would it be possible from the OUTPUT and SEND functio
On Wed, 2022-01-19 at 19:38 +, Garfield Lewis wrote:
> I am creating a new type and would like to know if it was possible to access
> the CTID for the row affected by the INPUT and RECEIVE functions of the new
> type?
> Actually, would it be possible from the OUTPUT and SEND functions as well?
11 matches
Mail list logo
