I've got a moderately complex function defined which i then want to be
able to test the value of, as well as select the value:
select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold
from search_vectorspace where threshold > 0 order by threshold desc;
I've tried it both with and without an AS alias, but in both instances
pgsql complains that the column does not exist. I would like to be able
to use the value computed with out having to recompute it every place i
wish to use the value. I've not had much luck finding this information
in the Postgres documentation. Anyone know what syntax i should be using?
thanks,
Stephen
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html 7 2155
On Monday 01 March 2004 01:04, Stephen Howard wrote: I've got a moderately complex function defined which i then want to be
able to test the value of, as well as select the value:
select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold from search_vectorspace where threshold > 0 order by threshold desc;
Can't be done that way, I'm afraid. The aliasing is defined as occuring after
the where clause has been evaluated.
However, you can mark functions as immutable/stable/volatile which can allow
PG to cache the query results. See the manuals (CREATE FUNCTION) for details.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
On Mon, Mar 01, 2004 at 09:21:32AM +0000, Richard Huxton wrote: On Monday 01 March 2004 01:04, Stephen Howard wrote: I've got a moderately complex function defined which i then want to be
able to test the value of, as well as select the value:
select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold from search_vectorspace where threshold > 0 order by threshold desc; Can't be done that way, I'm afraid. The aliasing is defined as occuring after the where clause has been evaluated. However, you can mark functions as immutable/stable/volatile which can allow PG to cache the query results. See the manuals (CREATE FUNCTION) for details.
Or wrap the query in a another query, like:
SELECT * from
(select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold
from search_vectorspace where threshold > 0) AS x
order by threshold desc;
Hope this helps,
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ If the Catholic church can survive the printing press, science fiction will certainly weather the advent of bookwarez. http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQFAQwizY5Twig3Ge+YRAhbeAKC5okljZwDZskN6d1QCyb KNpKEHeACg1cXE
W1A0yzZy/HgrpgvuSTr9xd8=
=n8QV
-----END PGP SIGNATURE-----
Hello
Is there any documentation that lists all the
PostgreSQL reserved words and function names?
Just dont want to create object names with those
words?
Karam
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
Karam Chand wrote: Hello
Is there any documentation that lists all the PostgreSQL reserved words and function names?
Just dont want to create object names with those words? http://www.postgresql.org/docs/7.4/s...-appendix.html
Mike Mascari
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
Hey
Thanks for the pointer. In MySQL ( which I had been
using for a long time )...YEAR comes under
miscellenous function..like date etc. and keywords are
given as select, group etc.
What about PostgrSQL?
Regards
Karam
--- Mike Mascari <ma*****@mascari.com> wrote: Karam Chand wrote:
Hello
Is there any documentation that lists all the PostgreSQL reserved words and function names?
Just dont want to create object names with those words? http://www.postgresql.org/docs/7.4/s...-appendix.html Mike Mascari
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On 2004.03.01 03:21 Richard Huxton wrote: On Monday 01 March 2004 01:04, Stephen Howard wrote: I've got a moderately complex function defined which i then want to be able to test the value of, as well as select the value:
select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as
threshold from search_vectorspace where threshold > 0 order by threshold desc;
However, you can mark functions as immutable/stable/volatile which can allow PG to cache the query results. See the manuals (CREATE FUNCTION) for details.
Depending on your requirements you may be able to store the results
in a temporary table CREATE TABLE TEMP ... ; INSERT INTO...
Don't know that this is a better alternative.
Karl <ko*@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
I've decided the STABLE keyword is probably the best bet. Makes the
query a bit ugly, but does what i want.
Karl O. Pinc wrote: On 2004.03.01 03:21 Richard Huxton wrote:
On Monday 01 March 2004 01:04, Stephen Howard wrote: > I've got a moderately complex function defined which i then want to be > > able to test the value of, as well as select the value: > > select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold > from search_vectorspace where threshold > 0 order by threshold desc;
However, you can mark functions as immutable/stable/volatile which can allow PG to cache the query results. See the manuals (CREATE FUNCTION) for details.
Depending on your requirements you may be able to store the results in a temporary table CREATE TABLE TEMP ... ; INSERT INTO...
Don't know that this is a better alternative.
Karl <ko*@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Elaine Jackson |
last post by:
List comprehensions don't work the way you intuitively expect them to work. I
realize many people have no intuitions about how list comprehensions 'should'
work, so if you recognize yourself in...
|
by: DMAC |
last post by:
If i want to split a computed column into two or more columns based on
the the length (its a varchar) of the computed column, how often will
sql server determine what the computed column is?...
|
by: war_wheelan |
last post by:
I am very new to Transact-SQL programming and don't have a programming
background and was hoping that someone could point me in the right
direction. I have a SELECT statement SELECT FIXID,...
|
by: Henning N?rg?rd |
last post by:
I'm working as software developer mostely om SQL-server platform.
On SQL-server we are using a lot of "Computed Columns"
Does anyone know if that is possible to do in DB2 too ?
I mean - define...
|
by: William Wisnieski |
last post by:
Hello Everyone,
I have a query by form with several list boxes. The user selects items from
the list boxes and clicks a button that returns results in a datasheet
subform.
One of the list...
|
by: Remaniak |
last post by:
Hi all,
In my query I am trying to select values from my table ("data table") which lie between two values that are stored in a different table ("Contract list double 71")
My Code is:
...
|
by: Jim.Mueksch |
last post by:
I am having a problem with using calculated values in a WHERE clause.
My query is below. DB2 gives me this error message: Error: SQL0206N
"APPRAISAL_LESS_PRICE" is not valid in the context where...
|
by: Aamir Mahmood |
last post by:
Hi All
I have DataTable object. Is there a way that I can know which fields
(columns) in the table are computed.
Apparantly the DataTable.Columns returns all columns both computed and
other....
|
by: GTalbot |
last post by:
Hello fellow comp.infosystems.www.authoring.stylesheets colleagues,
Imagine this situation:
#grand-parent-abs-pos
{
height: 400px;
position: absolute;
width: 600px;
}
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |