Using Regular expressions with Numeric value

Question

Using Postgresql 9.2

What select statement would be used to find all numeric results that end with .00

Say, from this example:

 Trans Amt
|-------|
-57059.44
-239.00
-100.61
-181.33
-100.00

I would only want to see the -100.00 and -239.00

Trenton Trama · Accepted Answer · 2013-11-06 20:12:48Z

1

Try SELECT * from TABLE where TRANS_AMT = floor(TRANS_AMT);

answered Nov 6, 2013 at 20:12

Trenton Trama

4,9301 gold badge25 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

roman · Accepted Answer · 2013-11-06 20:16:01Z

1

May be

select * from Table1 where TransAmt = TransAmt::int

answered Nov 6, 2013 at 20:16

roman

118k30 gold badges205 silver badges209 bronze badges

NotMe · Accepted Answer · 2013-11-06 20:30:55Z

0

Why do you think you need regular expressions?

select n from t where n = trunc(n);

answered Nov 6, 2013 at 20:30

NotMe

1