# HG changeset patch # User Miles Bader # Date 965659972 0 # Node ID ae938744b6b1063a4f858149618f67fbea79ee50 # Parent 297909766badb314a84c6da87fe82344b37c5ffe (sql-magic-go): Use comint-bol instead of explicitly matching comint-prompt-regexp. (sql-copy-column): Use comint-line-beginning-position instead of explicitly matching comint-prompt-regexp. diff -r 297909766bad -r ae938744b6b1 lisp/progmodes/sql.el --- a/lisp/progmodes/sql.el Mon Aug 07 14:51:48 2000 +0000 +++ b/lisp/progmodes/sql.el Mon Aug 07 14:52:52 2000 +0000 @@ -664,8 +664,8 @@ (self-insert-command (prefix-numeric-value arg)) (if (and (equal sql-electric-stuff 'go) (save-excursion - (beginning-of-line) - (looking-at (concat sql-prompt-regexp "go\\b")))) + (comint-bol nil) + (looking-at "go\\b"))) (comint-send-input))) (defun sql-magic-semicolon (arg) @@ -885,21 +885,21 @@ (progn (forward-char 1) (backward-sexp 1) (point)) (progn (forward-sexp 1) (point)))) (goto-char (point-max)) - (cond - ;; if empty command line, insert SELECT - ((save-excursion (beginning-of-line) - (looking-at (concat comint-prompt-regexp "$"))) - (insert "SELECT ")) - ;; else if appending to INTO .* (, SELECT or ORDER BY, insert a comma - ((save-excursion - (re-search-backward "\\b\\(\\(into\\s-+\\S-+\\s-+(\\)\\|select\\|order by\\) .+" - (save-excursion (beginning-of-line) (point)) t)) - (insert ", ")) - ;; else insert a space - (t - (if (eq (preceding-char) ? ) - nil - (insert " ")))) + (let ((bol (comint-line-beginning-position))) + (cond + ;; if empty command line, insert SELECT + ((= bol (point)) + (insert "SELECT ")) + ;; else if appending to INTO .* (, SELECT or ORDER BY, insert a comma + ((save-excursion + (re-search-backward "\\b\\(\\(into\\s-+\\S-+\\s-+(\\)\\|select\\|order by\\) .+" + bol t)) + (insert ", ")) + ;; else insert a space + (t + (if (eq (preceding-char) ? ) + nil + (insert " "))))) ;; in any case, insert the column (insert column) (message "%s" column))))