Hi,
On Thu, Nov 10, 2022 at 06:27:21PM -0800, Kirk Parker wrote:
> I came across what seems like anomalous behavior regarding
> implicit conversion from a numeric type to text. You can write:
>
> select 3.1416 || '?';
>
> and the number implicitly converts to text and concatenates just fine,
I came across what seems like anomalous behavior regarding
implicit conversion from a numeric type to text. You can write:
select 3.1416 || '?';
and the number implicitly converts to text and concatenates just fine, but
writing:
select trim(3.1416);
fails with an error message. This se
jian he writes:
> seems pg_column_is_updatable, pg_relation_is_updatable not documented.
I think they're not documented because they're only intended as
support for some information_schema views.
regards, tom lane
Hi,
seems pg_column_is_updatable, pg_relation_is_updatable not documented.
example:
create view test_v_tenk1 AS
select abs(unique1),unique1 from tenk1;
select pg_catalog.pg_column_is_updatable('test_v_tenk1'::regclass,
2::smallint, false)
select events & 4 != 0 AS upd,
events & 8 != 0
