Unix Technical Forum

Wrong error message from server

This is a discussion on Wrong error message from server within the pgsql Bugs forums, part of the PostgreSQL category; --> ERROR: syntax error at or near "and" at character 307 Actually error is at character 618 ------------------------------------------------- /* DELETE ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 07-04-2008, 06:50 AM
Eugen.Konkov@aldec.com
 
Posts: n/a
Default Wrong error message from server

ERROR: syntax error at or near "and" at character 307

Actually error is at character 618
-------------------------------------------------
/*
DELETE FROM akh_test_suit_detail
WHERE ID in (
select atsd.id as id1
from akh_test_suit_detail atsd
left join akh_test_suit ats on ats.ID = atsd.test_suit_id
where atsd.test_group_id = 6204 and ats.suit_status_id = get_property_id( 'suit_status', 'IN DEV' )
)
-- */

-- /*
INSERT INTO akh_test_suit_detail
( test_suit_id, test_group_id )
select
atst.value::integer, atsd.test_group_id as id2
from akh_test_suit_detail atsd
left join akh_test_suit ats on ats.ID = atsd.test_suit_id
left join akh_test_suit_type atst on atst.ID = ats.test_suit_type_ID
where atsd.test_group_id = ? and ats.suit_status_ID = get_property( 'suit_status', 'IN DEV' )
group by atsd.test_group_id, atst.value
-- */

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:36 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com