Re: [SQL] array_in: '{}}'::text[]

From: Joe Conway <mail(at)joeconway(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [SQL] array_in: '{}}'::text[]
Date: 2004-08-28 22:41:27
Message-ID: 41310A17.5020405@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

Markus Bertheau wrote:
>
> Without looking at the code in a whole, you accept '{} ' as an empty
> array literal, so why is the special case for '{}' needed here?

It's a fast path for a common special case. Why spend any cycles parsing
if we can immediately recognize it? However, anything other than a
simple '{}' does require parsing.

Joe

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-08-28 22:55:11 Re: [PATCHES] BUG #1219: pgxs does not work fully
Previous Message Bruce Momjian 2004-08-28 22:29:39 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Browse pgsql-sql by date

  From Date Subject
Next Message Kenneth Gonsalves 2004-08-28 23:59:08 Re: backup of a specific schema
Previous Message Markus Bertheau 2004-08-28 20:09:20 Re: [SQL] array_in: '{}}'::text[]