Joe, do you need a TODO added for this?
---
Joe Conway wrote:
> Tom Lane wrote:
> > Joe Conway <[EMAIL PROTECTED]> writes:
> >
> >>So array[] should produce '{}' of (an array) type determined by the
> >>context? OK -- seem
Bruce Momjian wrote:
I guess we should put array-of-UNKNOWN on the list of things to look at
for 7.5.
Yeah; maybe something like this?
Delay resolution of array expression type as long as possible so that
assignment coercion can be performed on empty array expressions.
Joe
---
Added.
---
Joe Conway wrote:
> Bruce Momjian wrote:
> >>I guess we should put array-of-UNKNOWN on the list of things to look at
> >>for 7.5.
> >>
>
> Yeah; maybe something like this?
>
> Delay resolution of array expressi
Peter Eisentraut wrote:
* Using an array as a table source using UNNEST, something like:
select * from unnest(test.b);
(Check the exact spec to be sure; clause 7.6.)
select * from unnest(array['a','b']);
?column?
--
a
b
select * from unnest(array['a','b']) WITH ORDINALITY;
?column? | ?c
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
So array[] should produce '{}' of (an array) type determined by the
context? OK -- seems easy enough.
Is it? I think we'd decided that this could only reasonably be handled
by creating a datatype representing array-of-UNKNOWN. I'm afraid to
Peter Eisentraut wrote:
I tried readding the files now, I seems it got them now. Possibly cvs was
confused because those files already existed in the 7.3 branch so it
found "dead revisions" in the head branch.
Thanks, this fixed it for me.
Joe
---(end of broadcast)-
I tried readding the files now, I seems it got them now. Possibly cvs was
confused because those files already existed in the 7.3 branch so it
found "dead revisions" in the head branch.
Joe Conway writes:
> Hmmm, I just updated to cvs tip (so I could try this), did `configure`,
> `make clean`, a
On Sat, 28 Jun 2003, Joe Conway wrote:
> > Do I need to do something to get new language files?
>
> causing me problems. Did a "cvs add" get missed somewhere, or am I doing
> something wrong?
Yes, a couple of cvs add was forgotten.
Peter made an update with the comment "Merge PO file updates f
Peter Eisentraut wrote:
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of arrays.
::=
|
|
|
|
::=
::=
Joe Conway wrote:
FWIW, I find that if I remove "hr" and "tr" from this line in
/opt/src/pgsql/src/backend/nls.mk, everything goes fine:
AVAIL_LANGUAGES := cs de es hu ru sv zh_CN zh_TW
Do I need to do something to get new language files?
Replying to myself again ;-)
I was a bit too quick to sa
Joe Conway wrote:
Hmmm, I just updated to cvs tip (so I could try this), did `configure`,
`make clean`, and `make all` and I'm getting this failure:
make[2]: Leaving directory `/opt/src/pgsql/src/port'
make -C backend all
make[2]: Entering directory `/opt/src/pgsql/src/backend'
msgfmt -o po/cs.mo
Tom Lane wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups.
As of a few minutes
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Btw., it would be really nice if some limited form of this could get done,
> so I could finish the information schema views pertaining to group
> privileges. I'd just need a way to find out what users are in what
> groups.
As of a few minutes ago,
S
Peter Eisentraut wrote:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups. If unnest() would work for locally constant arguments, I
I wrote:
> * Using an array as a table source using UNNEST, something like:
>
> select * from unnest(test.b);
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out
Joe Conway writes:
> I don't see anything about multidimensional arrays at all. I take it
> this is SQL99 (ISO/IEC 9075-2:1999 (E))? Can you point to a more
> specific paragraph?
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
So array[] should produce '{}' of (an array) type determined by the
context? OK -- seems easy enough.
Is it? I think we'd decided that this could only reasonably be handled
by creating a datatype representing array-of-UNKNOWN. I'm afraid to
Joe Conway <[EMAIL PROTECTED]> writes:
> So array[] should produce '{}' of (an array) type determined by the
> context? OK -- seems easy enough.
Is it? I think we'd decided that this could only reasonably be handled
by creating a datatype representing array-of-UNKNOWN. I'm afraid to do
that bec
Tom Lane wrote:
It's just a matter of staking out what's considered an implemented
feature. The ARRAY[] syntax is definitely in, so if it needs a few
adjustments around the edges to make it more spec-compliant, no one
will blink at doing that during beta.
OK, but some of what Peter requested were
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Joe Conway wrote:
>> Yeah, but isn't feature freeze July 1?
> Yes, but once the "feature" is in, you can adjust it if it isn't
> working.
> I am just pointing out that beating the system is a popular hacker
> passtime during beta. :-)
It's just a matte
Joe Conway wrote:
> Bruce Momjian wrote:
> >>None of this is very difficult. I'll try to fit it in between now and
> >>Monday evening, but if not it's very doable for 7.5.
> >
> > Joe, you have to get in the swing of things --- beta isn't until July
> > 15, and even after that, you can fix bugs,
Bruce Momjian wrote:
None of this is very difficult. I'll try to fit it in between now and
Monday evening, but if not it's very doable for 7.5.
Joe, you have to get in the swing of things --- beta isn't until July
15, and even after that, you can fix bugs, so once it is in, you can
fiddle with it
> > * Some information schema work (doing that now...)
> >
> So I take it I need not worry about that?
>
>
> None of this is very difficult. I'll try to fit it in between now and
> Monday evening, but if not it's very doable for 7.5.
Joe, you have to get in the swing of things --- beta isn't u
Peter Eisentraut wrote:
Some nice advances to SQL standard array support were made, but there are
a few things that don't work yet in the sense of feature S091 "Basic array
support". Joe, do you want to take on some of these? They should be
pretty easy (for you).
* Declaration of multidimensional
Some nice advances to SQL standard array support were made, but there are
a few things that don't work yet in the sense of feature S091 "Basic array
support". Joe, do you want to take on some of these? They should be
pretty easy (for you).
* Declaration of multidimensional arrays (see clause 6.1
25 matches
Mail list logo
