how to i typecast string to integer - Postgres?

Question

This query, return this error.

operator does not exist: text = integer LINE 2: from mas_book ) as outp where outp.authors = 2 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts

public function authors($ids)
{
  $query = "select count(authors) from (select distinct regexp_split_to_table(author, E',') as authors
        from mas_book ) as outp where outp.authors = ".$ids;
        $result =   $this->db->query($query);
     return $result->result();
}

Community · Accepted Answer · 2017-05-23 12:33:30Z

3

If outp.authors value can be converted into Integer then You can use :

"select count(authors) from (select distinct regexp_split_to_table(author, E',') as authors
        from mas_book ) as outp where to_number(outp.authors,'9999999') = ".$ids;

If It is not work then See this Link

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Nov 26, 2015 at 9:53

Shubham Batra

2,3755 gold badges32 silver badges48 bronze badges

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

Comments

Shubham Batra · Accepted Answer · 2015-11-27 09:14:47Z

3

 SELECT COUNT(authors) FROM (SELECT DISTINCT regexp_split_to_table(author, E',') as authors
            FROM mas_book ) as outp WHERE outp.authors = ".'cast(.'$ids'. as character varying);

edited Nov 27, 2015 at 9:14

Shubham Batra

2,3755 gold badges32 silver badges48 bronze badges

answered Nov 26, 2015 at 10:42

satish kilari

7284 silver badges23 bronze badges

Collectives™ on Stack Overflow

how to i typecast string to integer - Postgres?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related