This I got, need some implicit way, like maybe in RULE on SELECT can we
write this ?
Thanks
Sridhar
OpenText
On Mon, May 30, 2016 at 1:05 PM, Michael Paquier
wrote:
> On Mon, May 30, 2016 at 4:25 PM, Sridhar N Bamandlapally
> wrote:
> > Hi
> >
> > Is there a way to implicit SELECT on UUID data
On Mon, May 30, 2016 at 4:25 PM, Sridhar N Bamandlapally
wrote:
> Hi
>
> Is there a way to implicit SELECT on UUID datatype in uppercase ?
You could always cast an UUID back to text and use that with upper(),
though you are not explaining what you are tying to achieve:
=# select upper(gen_random_
Hi
Is there a way to implicit SELECT on UUID datatype in uppercase ?
Please
Thanks
Sridhar
Hi,
Is there maybe GIST support patch for UUID datatype?
I do not it it concretly just for UUID column... it is more because of I
need it in EXCLUDE constraint...
CREATE TABLE test_exclude
{
id serial NOT NULL,
guid uuid NOT NULL,
valid_period period NOT NULL,
CONSTRAINT "test_excludepk" PRIMARY
Tom Lane wrote:
> (I believe that 8.3 takes braces too ... but it's pickier about where
> it allows dashes.)
This is what the 8.3 comment says:
/*
* We allow UUIDs in three input formats: 8x-4x-4x-4x-12x,
* {8x-4x-4x-4x-12x}, and 32x, where "nx" means n hexadecimal digits
* (only the first fo
On Mon, Jul 13, 2009 at 03:28:09PM -0400, Tom Lane wrote:
- David Kerr writes:
- > Tried w/o escaping:
- > insert into testuuid values ('{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}');
- > ERROR: invalid input syntax for uuid:
"{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}"
-
- Works for me:
-
- regression=#
David Kerr writes:
> Tried w/o escaping:
> insert into testuuid values ('{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}');
> ERROR: invalid input syntax for uuid: "{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}"
Works for me:
regression=# select '{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}'::uuid;
uui
In the docs for the uuid datatype it states:
(http://www.postgresql.org/docs/8.4/static/datatype-uuid.html)
PostgreSQL also accepts the following alternative forms for input: use of
upper-case digits, the standard format surrounded by braces, omitting some
or all hyphens, adding a hyphen after an