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
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
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
Considering postgresql performs so well for me here, why is the postgres site
search so fucking slow??
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
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
Hi,
Could someone please provide a demo of creating the type "Lo".
Regards,
Craig May
Enth Dimension
http://www.enthdimension.com.au
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
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
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
[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
>
>
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
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
(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
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
15 matches
Mail list logo
