Re: SELECT INTO without columns or star

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Zhang Mingli <zmlpostgres(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: SELECT INTO without columns or star
Date: 2023-03-31 15:13:28
Message-ID: CAKFQuwZ_ZPuqziYZ=0uBEEGRnUFPRa9cspnmGeWb6-Jq63-B0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 31, 2023 at 8:10 AM Zhang Mingli <zmlpostgres(at)gmail(dot)com> wrote:

> When I exec a sql SELECT INTO without columns or * by mistake, it succeeds:
>
>
Yes, a table may have zero columns by design.

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-03-31 15:26:24 Re: SELECT INTO without columns or star
Previous Message Zhang Mingli 2023-03-31 15:09:45 SELECT INTO without columns or star