Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

You will have to retype this query using an explicit cast

Status
Not open for further replies.
progolf069

progolf069

Programmer
Jun 13, 2001
37
0
0
US
Greetings Techies:

I am seeking some assistance in PSQL - Typecasting.

I have a product catalog created, and I am wanting to implement a price search feature. I want to allow the customer the oppurnunity to input a range of prices (high/low) that they are willing to pay for a product. Then I will query the database, and return anything that matches their search. The problem that I am running into, is that I have the money field in the database setup as type: money. I need to be able to typecast it to a double, or some floating point value for numeric comparison, as money is a "string" datatype (for apperance on the website).

Here is what I have for results up to now:
Code: 
ksonline=# select sku, yourcost from catitem where yourcost < 100.00;
ERROR:  Unable to identify an operator '<' for types 'money' and 'float8'
        You will have to retype this query using an explicit cast
ksonline=# 
ksonline=# select sku, yourcost from catitem where yourcost::real < 100.00;
ERROR:  Cannot cast type 'money' to 'float4'
ksonline=# 
ksonline=# select sku, yourcost from catitem where yourcost::double precision < 100.00;
ERROR:  Cannot cast type 'money' to 'float8'
ksonline=#

Any support you maybe able to provide will be greatly appreciated. Have a great day!

Ian Wickline
Webmaster, catalog.ksmerchandise.com

 
Sort by date Sort by votes
Dummy me, I was having a &quot;brain fart&quot; early this morning. I guess it is just going to be one of them days!

I put the type cast on the wrong side!

The correct cast is:

Code: 
  select sku, yourcost 
    from catitem 
   where yourcost < 100.00::money
order by yourcost desc;

Have a great day,
Ian
 
Upvote 0 Downvote
One note: The 'money' type is deprecated in PostgreSQL. Generally, it should just be replaced with 'numeric'. -------------------------------------------

Big Brother: &quot;War is Peace&quot; -- Big Business: &quot;Suspicion is Trust&quot;
(
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
107
wbower34
wbower34
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
115
dbuxton101
dbuxton101
beakerboy
  • Locked
  • Question
Query from tables sharing primary keys
Replies
0
Views
79
beakerboy
beakerboy
rs120p
  • Locked
  • Question
Which way to move pg_xlog why sym link and not Linux Mount point?
Replies
0
Views
114
rs120p
rs120p
LD50
  • Locked
  • Question
psql query output
Replies
1
Views
111
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top