Mysql Postgresql cast

Question

I have a column (varchar in mysql and a character varying in postgresql). I need to apply sum on the column and I need a cast syntax that works for both.

The db structure is old and has both int and varchar values. I can't change that.

look into regular expressions in PostgreSQL.

Chris Travers
– Chris Travers

2012-10-03 01:24:50 +00:00
Commented Oct 3, 2012 at 1:24 — Chris Travers
– Chris Travers, Commented Oct 3, 2012 at 1:24

Frank Heikens · Accepted Answer · 2010-09-20 10:51:54Z

1

Why do you use a VARCHAR? You can't SUM an apple and pear, that's not going to work. You can use CAST() to cast, but that will fail on PostgreSQL (and any other DBMS) when invalid data is detected.

SELECT
  CAST('1' AS int);

This will fail:

SELECT
  CAST('apple' AS int);

Use the correct datatypes.

answered Sep 20, 2010 at 10:51

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

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

Collectives™ on Stack Overflow

Mysql Postgresql cast

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related