Firstly an apology - I think this should be posted to the performance mailing list but
can anyone tell me how to subscribe to this please? The usual form to fill in is not
available on the website. Hopefully others in this list will find the answer of use
though.
Now the question. Does the n
>
> [select version() --> PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by
GCC 3.0.4]
>
> I'm getting hangups every day or so, I presume due to some open
transaction
> that insert/update/delete'ed on a table that is used by my main app
without
> a commit.
>
> Is there some way (in 7.2!) to find who
Hilary Forbes <[EMAIL PROTECTED]> writes:
> Now the question. Does the number of fields that you have in a record and indeed
> their size affect performance on a SELECT statement when only a subset of fields is
> being extracted? So suppose that I have
> f1 integer
> f2 varchar(4)
>
Hilary,
> Firstly an apology - I think this should be posted to the performance
> mailing list but can anyone tell me how to subscribe to this please? The
> usual form to fill in is not available on the website. Hopefully others in
> this list will find the answer of use though.
To: [EMAIL PROT
Hi
CREATE VIEW user_stuff ...select comand that displays what you want... ;
This might be what you want ?:-)
CREATE VIEW user_stuff
SELECT username AS "Username",userpassword AS
"Pass/Attribute",startdate::TEXT AS "Date/Value"
FROM user
UNION SELECT
user.username,userdetail.attributename,use
Thanks a lot Gaetano, Joe
Now, it is working.
--- Mendola Gaetano <[EMAIL PROTECTED]> escribió: >
From: "Mr Weinbach, Larry" <[EMAIL PROTECTED]>
>
> > But at execution time I am getting thi error :
> >
> > WARNING: Error occurred while executing PL/pgSQL
> > function word_case
> > WARNING: l
