Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> Urgh. I think this is a serious thinko in Michael Glaesemann's rewrite
> >> of interval_mul.
>
> > The reason interval_justify_hours is called by interval multiplication
> > is so multipling an interval '2 days, 4 hours' by 10 does
Bruce Momjian writes:
> OK, what about 1.5 * '1 day'. By my logic multiplication and division
> were by definition imprecise. Is the logic that we spill down only for
> non-integral values?
Right. Interval multiplication has always spilled fractional months
over to seconds, but never the rever
How can I search the Unicode byte code seqence?
There is a Unified CJK Ideographs in the following website:
http://www.unicode.org/charts/
I chose some characters within that pdf file but none of them
can be inserted into utf8 encoded table.
I took another screenshot from latest 8.1 beta 4:
ht
The following bug has been logged online:
Bug reference: 1997
Logged by: Patrick Kik
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: SLES 9
Description:Grammar error in phpPgAdmin 3.1
Details:
In Dutch, after deleting a column the text
Tom Lane wrote:
> Bruce Momjian writes:
> > OK, what about 1.5 * '1 day'. By my logic multiplication and division
> > were by definition imprecise. Is the logic that we spill down only for
> > non-integral values?
>
> Right. Interval multiplication has always spilled fractional months
> over t
The following bug has been logged online:
Bug reference: 1998
Logged by: Dmitry Panov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.4
Operating system: Linux
Description:transaction locks parent record when it shouldn't
Details:
Hi,
I discovered that ins
Dmitry Panov wrote:
> I discovered that inserting a child record locks parent record so that if
> another translation tries to insert another child record which references
> the same parent.
This is fixed in 8.1.
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
"
Hi,
I have a query that throws error "RIGHT JOIN is only supported with
merge-joinable join conditions".
This should allow it to be reproduce.
create table table1 (t1id integer not null, extension integer not null);
create table table2 (t1id integer not null, t3id integer not null, original
i
Bruce Momjian writes:
> Tom Lane wrote:
>> Right. Interval multiplication has always spilled fractional months
>> over to seconds, but never the reverse. We have to have that same
>> policy now for fractional days.
> OK, I think that makes sense.
I've applied this change to interval_mul and in
"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> writes:
> I have a query that throws error "RIGHT JOIN is only supported with
> merge-joinable join conditions".
Wow, that's a goodie ... seems to fail all the way back to 7.2 ...
thanks for the report.
regards, tom lane
--
Hi,
I have a query that throws error "Variable not found in subplan target
lists".
This should allow it to be reproduce.
create temporary table table1 (
col1 integer not null,
col2 integer not null
);
create temporary table table2 ();
create or replace function udftable1row(integer, intege
"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> writes:
> select
>count(table3.*)
> from
>table1
>inner join table2
>on table1.t1id = table2.t1id
>and table1.extension in (table2.original, table2.replacement)
>left outer join table3
>on table2.t3id = table3.t3id
>and tab
"Jean-Pierre Pelletier" <[EMAIL PROTECTED]> writes:
> I have a query that throws error "Variable not found in subplan target
> lists".
> This should allow it to be reproduce.
This seems to be fixed already in beta4. But thanks for the report!
Relevant fix is:
2005-10-19 13:31 tgl
* s
Thanks for the speedy fix.
I agree that this is not a typical query, in it Table2.t3id and Table3.t3id
would always join
(a foreing key constraint ensure that) but columns from Table3 should
sometimes be excluded which is taken care by "table1.extension in
(table2.replacement)".
- Origin
On Tue, 25 Oct 2005 13:28:00 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> regression=# select '2005-10-29 13:22:00-04'::timestamptz + '1 day'::interval;
> ?column?
>
> 2005-10-30 13:22:00-05
> (1 row)
>
> regression=# select '2005-10-30 13:22:00-05'::timestamptz -
Nicholas Vinen wrote:
>
> Thanks for all this discussion, fixing, etc. I'm currently having
> "issues" getting postgres' date/time functions to do what I want. You
> have obviously spotted some of the reasons for this.
>
> Many of my issues disappear when I use 8.1, but it's still in beta. Is
Klint Gore wrote:
> On Tue, 25 Oct 2005 13:28:00 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> > regression=# select '2005-10-29 13:22:00-04'::timestamptz + '1
> > day'::interval;
> > ?column?
> >
> > 2005-10-30 13:22:00-05
> > (1 row)
> >
> > regression=# select
On Tue, 25 Oct 2005 23:41:54 -0400 (EDT), Bruce Momjian
wrote:
> test-> ('2005-10-30 13:22:00-05'::timestamptz -
> test(> '2005-10-29 13:22:00-04'::timestamptz);
> ?column?
>
>1 day 01:00:00
+---+
[sorry about the previous email, I quoted the wrong bit and clicked the
wrong button]
On Tue, 25 Oct 2005 23:41:54 -0400 (EDT), Bruce Momjian
wrote:
> test=> select
> test-> ('2005-10-30 13:22:00-05'::timestamptz -
> test(> '2005-10-29 13:22:00-04'::timestamptz);
>?colu
Klint Gore <[EMAIL PROTECTED]> writes:
> On Tue, 25 Oct 2005 23:41:54 -0400 (EDT), Bruce Momjian
> wrote:
>> test=> select
>> test-> ('2005-10-30 13:22:00-05'::timestamptz -
>> test(> '2005-10-29 13:22:00-04'::timestamptz);
>> ?column?
>> --
>> 25:00:00
>> (1 row)
> Is that actually the
test=> select
test-> ('2005-10-30 13:22:00-05'::timestamptz -
test(> '2005-10-29 13:22:00-04'::timestamptz);
?column?
--
25:00:00
(1 row)
Is that actually the correct answer?
Disregarding daylight savings, there is 25hrs betwee
John R Pierce <[EMAIL PROTECTED]> writes:
> the whole DST thing falls apart when you deal with places that don't
> respect it... arizona (except the navajo nation), for instance
> it would be impossible to calculate the 'correct' answer without knowing
> the exact location...
No, rather sa
Klint Gore <[EMAIL PROTECTED]> writes:
> I think this is what I was getting at. In my timezone 'Australia/NSW',
> we have daylight savings. Is that used any way when the calculation
> happens or the result is displayed?
Absolutely. The examples Bruce and I have been throwing around assume
US Ea
On Wed, 26 Oct 2005 00:44:50 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> John R Pierce <[EMAIL PROTECTED]> writes:
> > the whole DST thing falls apart when you deal with places that don't
> > respect it... arizona (except the navajo nation), for instance
>
> > it would be impossible to calc
John R Pierce <[EMAIL PROTECTED]> writes:
> heh. as an aside... the original reason I got ON this and the jdbc
> list was due to an issue we had with an inhouse java+pgsql program when
> it was deployed in Singapore... SGT wasn't recognized, then I
> discovered that China (another later deplo
On 2005-10-26, Tom Lane <[EMAIL PROTECTED]> wrote:
> Klint Gore <[EMAIL PROTECTED]> writes:
>> On Tue, 25 Oct 2005 23:41:54 -0400 (EDT), Bruce Momjian
>> wrote:
>>> test=> select
>>> test-> ('2005-10-30 13:22:00-05'::timestamptz -
>>> test(> '2005-10-29 13:22:00-04'::timestamptz);
>>> ?column?
>>
26 matches
Mail list logo
