draw
data.
Think of it like
select
(select count('1') from bar)
>from foo
foo and bar have nothing to do with each other so it turns into for each
row in foo count the number of records in bar.
klint.
+---+-+
: Klint Gore
e "onay_durum" in the FROM clause.
>
> Are you sure this is the exactly same query you tried on PostgreSQL 8.0?
Didn't the default in postgresql.conf for add_missing_from change in 8.1?
klint.
+---+-+
: Klint Gore: "No
sing_from = off ' to on in conf. file but
> it didn't work too.
> I have no idea about what to do:(
>
> 2007/5/14, Klint Gore <[EMAIL PROTECTED]>:
> >
> > On Mon, 14 May 2007 09:44:05 +0100, Heikki Linnakangas <
> > [EMAIL PROTECTED]> wrote:
ux-gnu, compiled by GCC 2.96"
redhat 7.2 (2.4.7-10)
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.: poss
On Sun, 23 Nov 2003 22:48:17 -0800 (PST), Stephan Szabo <[EMAIL PROTECTED]> wrote:
> On Mon, 24 Nov 2003, Klint Gore wrote:
>
> > I've got the message "ERROR: variable not found in subplan target lists"
> > when I have a union between 2 views. Both sel
On Tue, 25 Nov 2003 11:39:03 +1100, Klint Gore <[EMAIL PROTECTED]> wrote:
> On Sun, 23 Nov 2003 22:48:17 -0800 (PST), Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > On Mon, 24 Nov 2003, Klint Gore wrote:
> >
> > > I've got the message "ERROR: vari
On Tue, 25 Nov 2003 19:02:54 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Klint Gore <[EMAIL PROTECTED]> writes:
> >> Can you send a test case with table and view definitions, it's hard to
> >> generate one from just the information above.
>
> > ok.
klint.
(it was about "create table as select..." killing all connections to the
database)
+---+-----+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
t to SERVER
run cygserver-config
then start the cygserver service or run the cygserver in the background
then try the initdb again.
Can you post another message to the list with where the instructions you
followed are so they can be updated?
klint.
+---
If it's any help, on windows 8.0.0, I get a popup that says
'The instruction at "0x78001d90" referenced memory at "0x". The
memory could not be read."
klint.
+-------+-+
: Klint Gore
?
>
> I don't understand. Can you explain what the problem is?
I think they mean that it doesn't do short-circuit evaluation.
[to tirny]
If so, see explanation in the documentation at the bottom of
http://www.postgresql.org/docs/8.0/static/sql-expressions.html
klint.
+
table_one.
Try "select field1 from table_one group by field1 having count(*) > 1"
and see if it gives you any results.
If you do get results, then you need to put the distinct into the insert
statement.
INSERT INTO table_two (field1) (SELECT distinct field1 FROM table_one);
kli
I think this is a case of overenthusiastic propagation of implied
> equalities. Do you know offhand if it fails in 8.0.* or earlier
> branches?
fails on 7.4.7 (rh9) and 8.0.0 (win) for me.
klint.
+---+-+
: Klint Gore
unctions if they desire.
Where does textcat fit into things?
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.
On Thu, 13 Oct 2005 16:24:23 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> BTW, another issue here is that if we did merge the first DECLARE with
> the scope of auto-declared variables, it would be a non backwards
> compatible change. Right now you can do, say,
>
> declare found int;
>
> an
--
-
PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222
(Red Hat Linux 3.2.2-5)
(1 row)
+---+-+
: Klint Gore
'::timestamptz +
('2005-10-30 13:22:00-05'::timestamptz -
'2005-10-29 13:22:00-04'::timestamptz)) at time zone 'EST';
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED]
--
>1 day 01:00:00
+---+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.: possibilities :
: Mail University of New England : are useles
uthern/northern hemisphere respectively).
Or have I missed something obvious?
klint.
+-------+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.
when the calculation
happens or the result is displayed?
In the examples we've been using, does anything change if the -05 and
-04 are changed to timezones (EDT/PST/...)?
klint.
+---+-+
: Klint Gore
20 matches
Mail list logo
