"Jackson, DeJuan" wrote:
> > I'm looking for a way that my Perl program can look up the names of
> > the
> > tables in a database. Is there a way to do this?
>
> I thought for sure this was on the FAQ...
Maybe it isn't yet, but it is in "Administrative Tasks" chapter of the users's manual
(alo
Hi,
I am joining two or more tables on the column that has quite a number
of nulls, assuming 'a.key = b.key' to be a valid expression even when
both operands are NULLs. The result set is way smaller that I
expect. Could that be because the two NULLs do not match?
I guess there are two possible
Charles Curley wrote:
>
> Ulf Mehlig wrote:
>
> > In my opinion, the regexps are much more powerfull compared to "like
> > '%anything'"-statements; but the regular expression syntax is a little
> > bit weird, and if you have a look in the docs of programs which
> > heavily depend on regexps (per
Because new keywords have been added since the original manuals were written, some of
the examples may not work any longer, such as this:
(in the files known to me as userguide.ps or admin.html)
> This query lists all binary operators.
>
> SELECT o.oprname AS binary_op,
>
> I can't put the output of \df command to a file.
psql -d database -c "\df" > file
> > Is it possible to manipulate the way an index is created by using
> > functions?
Yes, it is possible:
\h create index
Command: create index
Description: construct an index
Syntax:
CREATE [UNIQUE] INDEX indexname ON class_name [USING access_method]
( attr1 [type_class1], ...attrN | f
> I also think the ticks that Michael is talking about are required. You can
> usually find more information about the "copy" error in the server.log
> (don't know where this is located on your system).
The file name must be enclosed in single closing quotes ('\047'). And
by the way, psql (if b
Konstantinos Vassiliadis wrote:
>
> Hi
> I am new to Postgres. I am trying to load a C function in Postgres under
> Red Hat Linux.
> I compile using
> gcc -I$PGROOT -I$PGROOT/include -I$PGROOT/src/include -c phone.c
> to produce the object file 'phone.o'
> Then I link using
> ld -Bdynamic -o ph
Sorry I could not keep up with your progress -- I am grossly
overcommited :(
Konstantinos Vassiliadis wrote:
>
> Thanks in advance for your help.
> I had a look at your defined type. I have some questions:
> a) I don't really understand the syntax of the Makefile. I understand it
> is required t
The posting I just ran into while reading my other list offers such
a clear insight into book printing that I couldn't stand the temptation
of forwarding it here. The book in question is rather controversial,
but no more so than your average book on software would be. Note point
3 -- it pretty muc
> This seems like a simple SQL command, but I'm getting errors.
> Running 6.5.0 under RedHat 5.2:
>
> db=> select count(distinct customer_username) from customerdata;
> ERROR: parser: parse error at or near "distinct"
>
> How do you get a count of distinct data output via postgres?
SELECT cus
> I was looking for a DBMS that supports multidimensional index structures
> like rectangles and points. During my search I found the link to the
> PostgreSQL system.
It does have the R-tree access method and a set of 2-D object types,
such as points, rectangles and polygons. It is also extensibl
I am wondering whether it's normal to see dropping a btree improve the
query which could never complete enough that it completes in a blink?
I realize the data I have here represent the worst possible input to
btree, and I'm probably better off without any index at all, but I
guess it is somethin
> > When the postmaster dies, init will automatically
> > respawn it, much the same as getty, or xdm, etc.
> > Now, since init will be starting the postmaster,
> > the /etc/rc.d/init.d script should be removed and
> > the links to it in /etc/rc.d/rc[whatever].d should
> > also be removed (or yo
Frank Mandarino wrote:
> Thanks for your response.
>
> I knew from the programming documentation that the opclass was optional.
> I'm pretty sure, although I will check again tonight, that I tried
> creating the index without specifying the opclass, but I found that the
> index was still not use
> NOTICE: BufferAlloc: cannot write block 990 for joblist/central
Whenever I saw this error it was caused by the full filesystem in the
data/base/ directory.
--Gene
> The other end of the spectrum is where you load the payware VMWare stuff.
> It allows you to emulate a complete new PC with it's own BIOS on Linux.
> Basically you run Linux, and then within Linux you can boot up one or even
> more virtual PCs which can run DOS, Windows, OS/2 Linux even and so o
> Whats BSD ?? Hows itcompare to linux ?
>
> Newbie you know
This conversation develops at a remarkable speed; it's just the
direction that apperas to be wrong. This site should be able to
absorb it:
http://www.unix-wizards.com/
Also, anyone having questions as to which of the systems is bett
> select key from inv_word_i where word='whatever' order by count desc ;
>
> and this is fast, however, if I use:
>
> select key from inv_word_i where word~'^whatever.*' order by count desc ;
>
> it is very slow.
Did you try '^whatever' instead of '^whatever.*'? Based on common
sense, the form
> > unfortunately '^whatever.*' is what I'm trying to locate (ie: all words
> > starting with whatever, but with nay trailing text), the problem seems to be in
> > the termination of the index scan, not in the actual regex match (which actually
> > seems very good, speed wise..) otherwise I could
> Greetings.
>
> Using pg6.5.1 on Solaris 2.6, I'm trying to create a very simple function
> using plpgsql. Here's the code I've executed:
>
> /*
> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
> '/opt/pgsql/lib/plpgsql.so' LANGUAGE 'C';
>
> CREATE TRUSTED PROCEDURAL LANGUAGE
> Hi,
>
> I just found a reference to descriptions to functions/tables/...etc.
> and am now wondering how to add them myself?
>
> Joost Roeleveld
not sure if there is a shortcut to this (it's short enough already):
INSERT INTO pg_description (objoid, description)
SELECT oid, 'your descripti
22 matches
Mail list logo
