Jack,
> On version 7.3.2, 'truncate' can not be executed from pl/pgsql. But it
> isn't stated on change notes. Is it a bug?
No, it's a fix.
TRUNCATE, VACUUM, ANALYZE, and REINDEX all perform COMMIT statements as part
of their operation. If called within a function, this could cause part of
Folks,
> > Well, Shane Wright just wrote an PostgreSQL syntax highlighter for Kate
(part
> > of the KDE project) Unfortunately, it's part of KDE 3.1, so if you're
using a
> > packaged distribution you'll have to wait for the next distribution
version.
Actually, Shane just sent me the XML fil
Would it not be more reasonable to have array_dims return an int or int[]?
Has anyone ever seen an array that does not start at 1?
The other problem I find with array_dims returning text is when you have a
multi-dimentional array like this IIRC;
array_dims('{{asd,fgh,jkl},{zxc,vbn,mlk}}') = '[1
On Wed, 19 Feb 2003, Matthew Nuzum wrote:
> Sorry for the simple question, but I'm struggling with a join.
>
> I'm creating a view that will show data from 4 tables. The problem is, I
> want the view to show a record for every entry in the "users" table, even if
> there is no matching entry all
You can generate indexes for your custom functions, though,
which will speed things up. This is what I've done, successfully.
Troy
>
> JBJ <[EMAIL PROTECTED]> writes:
> > Furthermore I will have to be able to switch between is_IS and others to
> > get the correct sort order ( russian sort o
