postgresql syntax error?

Question

I can't identify the syntax mistake on this query, where´s the syntax mistake?

select c_name, c_address, c_mktsegment , count(*) as cnt customer join orders on c_custkey=o_custkey 
where
(c_name like %r% AND c_address like %a%) OR c_mktsegment like ='%t%'   
group by c_name, c_address, c_mktsegment having count(*)>2;

No FROM clause ? With a join ?

Luc M
– Luc M

2012-09-19 02:43:37 +00:00
Commented Sep 19, 2012 at 2:43 — Luc M
– Luc M, Commented Sep 19, 2012 at 2:43

Mark Byers · Accepted Answer · 2012-09-19 02:49:10Z

4

One error is you have missing quotes here:

(c_name like %r% AND c_address like %a%)

Should be:

(c_name like '%r%' AND c_address like '%a%')

Another problem mentioned in the comments is you missed the FROM keyword:

select c_name, c_address, c_mktsegment , count(*) as cnt customer

Should be:

SELECT c_name, c_address, c_mktsegment , count(*) as cnt
FROM customer

There may also be other errors. But you can be sure that both these problems are actually problems and they do need to be fixed. I'd strongly recommend that you fix them before further investigating any other problems.

edited Sep 19, 2012 at 2:49

answered Sep 19, 2012 at 2:39

Mark Byers

843k202 gold badges1.6k silver badges1.5k bronze badges

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

Comments

Hunter · Accepted Answer · 2012-09-19 18:53:33Z

0

I am adding one more thing in the answer given by Mark Byers is that

you cannot use = with like operator

so you have to replace OR c_mktsegment like ='%t%' with OR c_mktsegment like '%t%'

answered Sep 19, 2012 at 18:53

Hunter

90010 silver badges19 bronze badges

Collectives™ on Stack Overflow

postgresql syntax error?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related