Hello,
I have following problem with PostgreSQL 6.5.3, I haven't possiblity
to check it on 7.0 and I want to know is it possible to run such query:
SELECTk.pic, id_g, id_k, count(*)
FROM kart k, pictues p
WHERE k.pic = p.pic
GROUP BY k.pic
PICTURES(pic,id_g,id_k)
KART (pic,email,mess,d
(Aplolgies to Mr. McCoy, to whom I mailed this awnser in error)
Mr. Bajerski,
> > I've got answer from Postgres
> > "Illegal attributes or non-group column"
> >
> > Is it error in query or in parser ?
It's your query. In a GROUP BY query, all named columns must either
contain and aggregate fun
Hi All,
I'm planning to have data in a tree structure when fetched.
e.g.
NODE1
+ --- NODE1_1
+ --- NODE1_2
|+ --- NODE1_2_1
+ --- NODE1_3
Is this possible? How?
I would really appreciate any help.
Sherwin
[EMAIL PROTECTED] writes:
> Hello,
> I have following problem with PostgreSQL 6.5.3, I haven't possiblity
> to check it on 7.0 and I want to know is it possible to run such query:
>
> SELECTk.pic, id_g, id_k, count(*)
> FROM kart k, pictues p
> WHERE k.pic = p.pic
> GROUP BY k.pic
>
>
On Mon, 23 Oct 2000 [EMAIL PROTECTED] wrote:
> Hello,
> I have following problem with PostgreSQL 6.5.3, I haven't possiblity
> to check it on 7.0 and I want to know is it possible to run such query:
>
> SELECTk.pic, id_g, id_k, count(*)
> FROM kart k, pictues p
> WHERE k.pic = p.pic
> G
On Mon, 23 Oct 2000 [EMAIL PROTECTED] wrote:
> I have following problem with PostgreSQL 6.5.3, I haven't possiblity
> to check it on 7.0 and I want to know is it possible to run such query:
>
> SELECTk.pic, id_g, id_k, count(*)
What table do these come fr
Hi,
Could someone please provide a demo of creating the type "Lo".
Regards,
Craig May
Enth Dimension
http://www.enthdimension.com.au
Hi, I would to know if there is any articles or books that talk about
pl/pgsql performance especially versus C. Thanking you in advance for
your help.
Regards.
Najm
I am just getting started with pgsql and have read available docs I can
find.
I know I can match a row in a where clause using a regular expression.
How can I use what was regexp matched (e.g. perl $1,$2, etc...) as a column
assignment ?
I'm looking for something like this?
select ...
...
$1 of
Considering postgresql performs so well for me here, why is the postgres site
search so fucking slow??
On Tue, 24 Oct 2000, Craig May wrote:
>
> Considering postgresql performs so well for me here, why is the
> postgres site search so fucking slow??
The search engine used (udmsearch) isn't written to be the most efficient
as far as making use of SQL features are concerned (ie. it was designed
wi
Hi,
Does anyone know if it's possible to do a like query on an oid (blob)?
Regards,
Craig May
Enth Dimension
http://www.enthdimension.com.au
FROM test.pl of DBD-Pg-0.93.tar ...
# test large objects
# create large object from binary file
my ($ascii, $pgin);
foreach $ascii (0..255) {
$pgin .= chr($ascii);
};
my $PGIN = '/tmp/pgin';
open(PGIN, ">$PGIN") or die "can not open $PGIN";
print PGIN $pgin;
close
Mikheev, Vadim wrote:
> Try this for both FK tables:
>
> create table tmp2(idx2 int4, col2 int4, constraint
> tmpcon2 foreign key(col2) references tmp1(idx) INITIALLY DEFERRED);
>
> This will defer constraint checks till transaction commit...
> though constraint triggers should use SnapshotDirty i
Do you want to have a field name called "SELECT"?
If so, you can use brackets in SQL 7 or higher. [SELECT]
You can also use quoted identifiers (and the double quote) "SELECT"
Keith
"lesstif" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> what is the best wa
15 matches
Mail list logo
